Hi Holger.
Thank you. Can you show me how that can be done?
Hi Holger.
Thank you. Can you show me how that can be done?
Hi, kosherboy,
I just had the ListFillRange on the sheet, added a listbox from the ActiveX controls, limited it to single select, assigned the ListFilRange, ended the "developer mode", put the code behind the sheet:
Ciao,![]()
Private Sub ListBox1_Change() myMacro ListBox1.ListIndex + 1 End Sub Sub myMacro(lngNumber As Long) MsgBox "Called from Listbox entry: " & lngNumber End Sub
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger, it worked, thank you!
Hey Holger, i spent some time and figured out the problem
See you around![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks