MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to activate Worksheet_change event

  Asked By: Dale    Date: Dec 06    Category: MS Office    Views: 942

I had a small requirement. I have added a combobox in excel sheet and
gave a input range and also cell link to this combobox. Whenever I
select a value in combobox I want to show certain data in Excel. For
this I want to use worksheet_change event to capture the value in cell
link of the above combo box. However the worksheet_change event is not
occurring eventhough the cell link is updating with list index of
combo box.

I hope I made the problem clear. Please let me know of any suggestions



4 Answers Found

Answer #1    Answered By: Madaniyah Malik     Answered On: Dec 06

Maybe link  another cell  to the link cell and trap it using the
Worksheet_Calculate event.

Answer #2    Answered By: Essie Garza     Answered On: Dec 06

"However the worksheet_change  event is not occurring eventhough the cell  link is
updating with list  index of combo  box. "

Have you turned off events and forgot to turn them back on? Or during a debug,
stopped a macro before it was able to turn events back on? Are other event
macros working in your file?

Application.EnableEvents = False
Application.EnableEvents = True

Answer #3    Answered By: Eleanor Hunt     Answered On: Dec 06

could you post the code that is not working in your worksheet change event  so we
can see if there's something going wrong with that?

Answer #4    Answered By: Nahal Malik     Answered On: Dec 06

You really need to grab the combo-box's change event, not the cell's. I
don't think Excel generates a cell  change event  in this situation.

Alternatively, link  another cell directly to the target cell. IIRC Excel
will generate a change event for this second cell.

Didn't find what you were looking for? Find more on How to activate Worksheet_change event Or get search suggestion and latest updates.