Storing a Value

Could someone please help with my code. I have a command button in a user form that I am trying to extract the value from a combo box in order to print a certain sheet.

Private Sub cmd_pullsheet()
If cbo_pullsheet = FIESTA Then

Workbooks.Open Filename:="M:\doc\PRODUCTION\ITEMS\FIESTA.xls"
Range("B6").Select
Activecell.value = txt_pullsheettubs
ActiveWindow.SelectedSheets.Printout Copies:=1, Collate:=True
ActiveWorkbook.Save
ActiveWindow.Close

End if

End Sub


cbo_pullsheet is a combo box with a list of items

FIESTA
ISLAND CRUNCH
ORIGINAL
.......

Is there anyway that I can have the code take what value is in the combo box(cbo_pullsheet) and then print that sheet that matches.

For instance if cbo_pullsheet = ISLAND CRUNCH then it would print the sheet from the same path, except for the last file would be ISLAND CRUNCH instead of FIESTA.

Any help would be greatly appreciated.

Thanks in Advance

Josh

Josh

Try this code instead:

Please Login or Register  to view this content.

Hope this helps,
theDude