Call a macro from a combobox - how ??

G

gravesen

HI I have a combobox created in forms.
I would like have a label and a tekst that I can insert in the documen
but also I would like very much to run a macro that is in my newmacros
Can anyone tell me how this is done. I have tryed something like this
I don't get an error but the macro is not run.
I am trying to run the macro testet.

Private Sub UserForm_Initialize()
With cboProgram
.AddItem "This is the label"
Application.Run MacroName:="testet"

.AddItem "Sales Partner"
cboProgram.ControlTipText = "Test3"
.AddItem "Support Center"
cboProgram.ControlTipText = "Test4"
.AddItem "Another Company"
End With
End Sub





Thanks
Lars Gravese
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
Word macro that can call cells out of Excel for a find and replace 0
list box remove item by combobox 4
Using variables in a combobox 1
Macro to Select text from a point given to a specific word 2
Setting combobox properties from Outlook 2007 Add-in 9
Inserting text at a bookmark with a Userform 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top