Showing a form in excel?????

P

philgill

Please help me here.
I have a workbook open with an entry screen.
Workbook name is "Home"
I have a worksheet selection form (frmOpenFile) that takes the mont
and year to determine which worksheet to open but when I try to open m
information input form (frmInput) It comes up with an error message
saying that the "Subscript is out of range".
It was working fine yesterday morning when I was working on it but no
I can't work out why it wont let me open the form???
This is driving me mad.
The codes simple
frmOpenfile.hide
frmInput.show

please help me
I'm using office X
 
D

DNF Karran

Without more info I can only suggest the form has been deleted or th
name is wrong.

Dunca
 
P

philgill

I have emailed this workbook to someone I know who does this stuff on
daily basis and he is stumped.
The form is there. I'm using the correct name etc.
I've just managed (i'm not sure how) to make the form appear but th
command hangs the application for around 10 secs then opens the form.
The file is attached if you would like to see for yourself!
Thanks
phi

Attachment filename: findhornstore.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=54941
 
D

DNF Karran

There is no reason in the code for this to fail- the error that you wer
getting suggested something was out of range, possibly the sheet yo
were calling depends where the error was.

The file works on my pc so not sure what the problem is.

Something I have noticed is you appear to have "over written" (for wan
of a better word) the Sheets object into a variable. THis can be see
as on the line "sheets("Home").Select", the line has a lower case "s
not "S".

I would recommend putting "Option Explicit" at the start of all of you
modules to avoid this happening.

Dunca
 
P

philgill

Thanks (i think),
I didn't quite understand your last statement but I have alread
decided to reprogram the whole thing.
I've spent more time trying this problem than it would have taken t
start from scratch.
If anyone can work out the problem please let me know how you did it o
what I have done wrong.
Thanks again Duncan for trying
phi
 
Top