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

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

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

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