Good day,
I have 4 combo boxes, one on each sheet (sheet 1 to sheet 4) all must display the same thing. When a user changes it on one sheet, it must update (and run its own macros) on all other sheets simultaneously.
How do I code this in VBA?
Thanks
Last edited by blh; 05-28-2014 at 12:48 PM.
Hello
Perhaps something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
No unfortunately not.
For example:
When a user changes ComboBox1 on sheet 1 to a value from a list it must also change the value of Combobox1 on sheet 2 (and 3 and 4...) to the same value and vice versa .
That is..a user can make changes to a combobox1 on any sheet and it will change ALL combobox1 values to the value the user selected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks