ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   onCHange event (https://www.excelbanter.com/excel-programming/412309-onchange-event.html)

geebee

onCHange event
 
hi,

i have a form combobox which i would like to invoke some VBA after a value
is selected from it. i tried the change event for the control in VBA but it
doesnt seem to be accurate. i also tried the LostFocus event. can someone
help me?

thanks in advance,
geebee


Jim Thomlinson

onCHange event
 
So you have a combo box from the forms toolbar. You can assign a macro to it
by right clicking the control and selecting Assign Macro. When a change is
made to the combo box the macro will fire.
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

i have a form combobox which i would like to invoke some VBA after a value
is selected from it. i tried the change event for the control in VBA but it
doesnt seem to be accurate. i also tried the LostFocus event. can someone
help me?

thanks in advance,
geebee



All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com