Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheets
I load a combo in sheet 2 and load it with data in sheet 1.Is there a
way where the combo can be refreshed automatically if I change the data in sheet1? Any help?VBA code needed.. Thanks ST |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheets
ST wrote:
I load a combo in sheet 2 and load it with data in sheet 1.Is there a way where the combo can be refreshed automatically if I change the data in sheet1? Any help?VBA code needed.. Thanks ST I use the worksheet_activate event for this. Since you will not see the combo till you actually go to sheet2, put a worksheet activate event on sheet2 that refreshes the box. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheets
Thanks Paul,
Its working.All I need to it is to call the function that populates the combo in the Sheet's activate event. Paul Lautman wrote: ST wrote: I load a combo in sheet 2 and load it with data in sheet 1.Is there a way where the combo can be refreshed automatically if I change the data in sheet1? Any help?VBA code needed.. Thanks ST I use the worksheet_activate event for this. Since you will not see the combo till you actually go to sheet2, put a worksheet activate event on sheet2 that refreshes the box. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheets
ST wrote:
Thanks Paul, Its working.All I need to it is to call the function that populates the combo in the Sheet's activate event. Are you asking how to do this or are you saying that you are just about to do it? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheets
Thanks So much.I ve done it.,Regards ST
Paul Lautman wrote: ST wrote: Thanks Paul, Its working.All I need to it is to call the function that populates the combo in the Sheet's activate event. Are you asking how to do this or are you saying that you are just about to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save sheets in new excel files, automatically? | Excel Worksheet Functions | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel |