Hi everybody.
I have 1 macro that i would like to be activated as soon as i select any item from a form control listbox (doesn't matter which item).
Is this possible?
Please note that i am not using an active X control but rather a form control.
Thank you.
Hi,
if you right click on the control, you can assign a macro... no ?
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
I know that.
Happens to be i just figured out my problem, the macro that was supposed to run automatically wasn't named right.
(do i deserve a rep for thislol)
Hi.
Try
considering that the listbox is linked in cell E5
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$5" Then 'Your Code Here End If End Sub
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
It worked like a charm, thanks!Originally Posted by marreco
Hi.
Try
considering that the listbox is linked in cell E5
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$5" Then 'Your Code Here End If End Sub
Hi.
click on the star.
then mark your post as solved, please!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks