Hi everybody.
The macro code below detects whether cell G5 is empty or not and if it's not empty it runs a macro (called "MyMacro")
However, when that cell gets populated via an item selected from a list-box the macro does not recognize right away that it's populated, only when i double-click on a random cell and then click out does the macro run.
Is there a way to make the macro as soon as an item is selected from the list box?
Please Login or Register to view this content.
Hi, kosherboy,
if you use an ActiveX-Component you may use the ListBox_Change-event to trigger the macro - why not use that?
Ciao,
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
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,Please Login or Register to view this content.
Holger
Holger, it worked, thank you!
Hi Holger. I ran through some issues with the active X list box so i am now using a form control list box. I plugged in your code into the form control but excel returned an error.
Can you advise me as to how i can plug your code in to the form control properly?
*the issue with the active X is that it keeps freezing. I saw online that a lot of people have the same issue and they were told to use form control.
Last edited by kosherboy; 04-30-2014 at 05:16 PM.
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks