ProgramEntries.Show 1 causes VBA to open up in break mode and
highlight the command. VBA does not give any error messages and there
is no error in the statement I providing VBA (I think). I can't
figure out what the heck is wrong with my command. Any ideas?

Private Sub CommandButton10_Click()
ProgramEntries.Show 1
End Sub

Command Button 10 is on a UserForm.

Any help is much appreciated!!!

if ProgramEntries is a userform, then you need to take out the "1".

ProgramEntries.Show

is Command Button 10 on the SAME userform???? if so, you're already
showing it if they're able to click it.....

if ProgramEntries is a 2nd userform you're trying to show, you might
need to hide the 1st one, first.
hope this helps
susan


On May 9, 10:37 am, wrote:
ProgramEntries.Show 1 causes VBA to open up in break mode and
highlight the command. VBA does not give any error messages and there
is no error in the statement I providing VBA (I think). I can't
figure out what the heck is wrong with my command. Any ideas?

Private Sub CommandButton10_Click()
ProgramEntries.Show 1
End Sub

Command Button 10 is on a UserForm.

Any help is much appreciated!!!

On May 9, 11:22 am, Susan wrote:
if ProgramEntries is a userform, then you need to take out the "1".

ProgramEntries.Show

is Command Button 10 on the SAME userform???? if so, you're already
showing it if they're able to click it.....

if ProgramEntries is a 2nd userform you're trying to show, you might
need to hide the 1st one, first.
hope this helps
susan

On May 9, 10:37 am, wrote:



ProgramEntries.Show 1 causes VBA to open up in break mode and
highlight the command. VBA does not give any error messages and there
is no error in the statement I providing VBA (I think). I can't
figure out what the heck is wrong with my command. Any ideas?

Private Sub CommandButton10_Click()
ProgramEntries.Show 1
End Sub

Command Button 10 is on a UserForm.

Any help is much appreciated!!!- Hide quoted text -

- Show quoted text -

Normally I don't add any digit after "whatever.show" but the computer
I am using has Excel 2000 on it and it any time there isn't a digit
after the "whatever.show" it crashes. Command Button 10 is on a
userform (form1a) that is suppose to open up a new user form
(ProgramEntries). I've created a work around but ultimately it's only
a "work around" and not a true fix...so any information is helpful. I
appreciate your help with this. Thanks alot Susan.