| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User form in copy of original file
Hey all,
I saved a copy or my original workbook. My user form works great in the original workbook, but when I open the second one the form says there is a bug. It hightlights the following part of the syntaxs Private Sub cboVend_Change() ShowValue cboVend End Sub In the second copy of the workbook I have made some new additions I added a automatic advanced filter to a completely differant worksheet. Could this be causing a problem? Thank you very much. -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User form in copy of original file
Are you linking the combo to that filtered data?
-- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... Hey all, I saved a copy or my original workbook. My user form works great in the original workbook, but when I open the second one the form says there is a bug. It hightlights the following part of the syntaxs Private Sub cboVend_Change() ShowValue cboVend End Sub In the second copy of the workbook I have made some new additions I added a automatic advanced filter to a completely differant worksheet. Could this be causing a problem? Thank you very much. -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User form in copy of original file
Based on a later posting, sounds like other changes were made as well - one
of which caused the error. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Are you linking the combo to that filtered data? -- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... Hey all, I saved a copy or my original workbook. My user form works great in the original workbook, but when I open the second one the form says there is a bug. It hightlights the following part of the syntaxs Private Sub cboVend_Change() ShowValue cboVend End Sub In the second copy of the workbook I have made some new additions I added a automatic advanced filter to a completely differant worksheet. Could this be causing a problem? Thank you very much. -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User form in copy of original file
Well are we surprised? No! <G
Bob "Tom Ogilvy" wrote in message ... Based on a later posting, sounds like other changes were made as well - one of which caused the error. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Are you linking the combo to that filtered data? -- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... Hey all, I saved a copy or my original workbook. My user form works great in the original workbook, but when I open the second one the form says there is a bug. It hightlights the following part of the syntaxs Private Sub cboVend_Change() ShowValue cboVend End Sub In the second copy of the workbook I have made some new additions I added a automatic advanced filter to a completely differant worksheet. Could this be causing a problem? Thank you very much. -- Though daily learning, I LOVE EXCEL! Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a new XL file form the Original XL data - Misho | Excel Discussion (Misc queries) | |||
| copy sheets selected on user form | Excel Programming | |||
| copy sheets selected on user form | Excel Programming | |||
| Copy file and closing original | Excel Programming | |||
| Copy from User form to Sheet macro | Excel Programming | |||
Hybrid Mode
