Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to access worksheet while form is running
How is this possible to do? I want to run a form and be able to select
what worksheet I want... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to access worksheet while form is running
Private Sub Userform_Initialize()
Dim sh as Worksheet for each sh in worksheets combobox1.AddItem sh.Name Next End Sub Private Sub Combobox1_Click() if combobox1.ListIndex < -1 then _ worksheets(combobox1.Value).Activate End sub -- Regards, Tom Ogilvy "Monte0682" wrote: How is this possible to do? I want to run a form and be able to select what worksheet I want... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to access worksheet while form is running
If you mean physically select a sheet while the userform is displayed
Userform1.show vbModeless -- Regards, Tom Ogilvy "Monte0682" wrote: How is this possible to do? I want to run a form and be able to select what worksheet I want... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to access worksheet while form is running
There is a set of tabs at the bottom of the workbook. And you can see the
list by right-clicking the navigation buttons to the left of them. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Monte0682" wrote in message ups.com... How is this possible to do? I want to run a form and be able to select what worksheet I want... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
be able to access worksheet while form is running
oops, mis-read it.
Try Worksheets("Sheet2").Activate -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Monte0682" wrote in message ups.com... How is this possible to do? I want to run a form and be able to select what worksheet I want... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Sheets (running from Access) | Excel Programming | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Running Access Query from Spreadsheet | Excel Discussion (Misc queries) | |||
Running Access queries from Excel | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |