Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jawna Mansour   on Oct 30 In MS Office Category.

  
Question Answered By: Kanchan Ap   on Oct 30

you seem to have it backeards (Or I blew the explanation).
I want to change the *linked cell* via code. NOT the combo box
control... I have code to simply change the value in a cell (that
happens to be linked to a combo box).

A more fuller, better explanation:
I use the combo box to allow the user to choose values which are used
to perform an operation (sends it to an external device) AND save it
in the sheet (by virtue of the comboBox function to the linked cell)
for use next time the sheet is opened, like preferences.

When the sheet is closed, the value in that cell & combo box may
become stale because the value it represents is in an external device
that I am controlling via serial I/O in the macros. When I re-load
the sheet, I give the user the option of updating the external device
with the value in the sheet (re-send to the device)...or...or I want
to have the abiity to update the *sheet* to the value in the external
device. SO, I just want to change the linked cell and have the
comboBox show the updated value --- WITHOUT having the
ComboBox_Change event  trigger (as a result) thus re-sending the value
TO the device (as a result of my changing the linked cell...because I
just got it from there!
Like I say, not a disaster, just a time killer. But Disabling the
Events aughta woik!.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Event Woes Or get search suggestion and latest updates.


Tagged: