Automating Spreadsheet Selection

[JAMESRTECH-MCSA]

Can you show me how I can make the sheet selected is based off a list box and a combo box together. This is the best I seen with what I am trying to do.

Listbox has 2 items which is labeled style.
Combo is the versions based off that style

Listbox has Base and uppers... "B" & "U" of sheetname.
Combo has DD .25, Open...etc

The idea behind mind is making a cutsheet app based on some xlsx sheets i have made, with formulas that change from one to another. To give amount. ....etc.... I have that done.

Output should display 3 sheets on one page. Option buttons to select cells of location. 1 2 3. After importing I have to put in data to update with formulas from those sheets.

OK. Sorry. Let me revert back to the main question. I need to make. The sheet selected. To be a variable? Based off of. First. A list box. Then second a combo box. Which will define the variable? For which sheet to copy over.

[JAMESRTECH-MCSA]

Example of sheet name..."BDD .25" "BOP" "UOP". (base drawer door, base open, upper open). if helps explain.

[JAMESRTECH-MCSA]

Can you show me how I can make the sheet selected is based off a list box and a combo box together. This is the best I seen with what I am trying to do.

Listbox has 2 items which is labeled style.
Combo is the versions based off that style

Listbox has Base and uppers... "B" & "U" of sheetname.
Combo has DD .25, Open...etc

The idea behind mind is making a cutsheet app based on some xlsx sheets i have made, with formulas that change from one to another. To give amount. ....etc.... I have that done.

Output should display 3 sheets on one page. Option buttons to select cells of location. 1 2 3. After importing I have to put in data to update with formulas from those sheets.

OK. Sorry. Let me revert back to the main question. I need to make. The sheet selected. To be a variable? Based off of. First. A list box. Then second a combo box. Which will define the variable? For which sheet to copy over.

Added attachments of excel sheet, and the design view

[westconn1]

the methods in this thread are for using ADO to connect to excel data, it sounds more like you want to automate excel to work with the excel object model

see the thread, at the top of the office development forum, on automating MS office applications

[Shaggy Hiker]

Since the question seems to be Excel rather than VB6, I moved the posts out to a new thread in the Office Development, which seems more appropriate. The techniques used don't seem to be related to the original thread, as westconn1 noted. If this is incorrect, the thread can be moved again. For the sake of completeness, the original was here (since it was mentioned a couple times):

http://www.vbforums.com/showthread.p...25#post5194425