Hey guys,
This is something I'm really not sure why is happening. I keep getting an "Object variable or With Block variable not set" error with the following code highlighted when I debug:
[vba]pdfForm.Show[/vba]
This only happens when I bring something from work (Excel 2000) home (Excel 2003) and work on my excel file.
I don't know where to start looking, any ideas?
TIA
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Step through your Userform code or put Break points in to see where the code bugs out.
Kind Regards,
Ivan F Moala From the City of Sails
Thanks Ivan, I'll give it a whirl.
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Most likely in Userform_Initialize(). These can be a pain in the ass to find. Strange that it would work on 2000, but not 2003.
You said it. Pain in the ass. Especially cause VBA just highlights the Userform.Show line when you open the form by another module (instead of just testing it from the VBE)....sigh.Originally Posted by BlueCactus
And yes you're right...it was in _Initialize()
It ended up being 2 things wrong. First part was when I edited it and forgot a End With statement (i.e. the first error). The second I don't remember entirely what it was...I think it was something like a line of code that you couldn't use in 2000...or SOMETHING like that...Don't know why I'm drawing a blank.
Anyway, it's fixed for now. Thanks for the suggestions guys
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Do you have your VBIDE options set to 'Break in Class Module'
Or Break on All Errors.
Or you can hit F8 when the Show is highlighted to step through the Initialize code.
Bob and Norie, thank you both
That will surely save me time now
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
...and don't forget Compile VBAProject.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Will do...and don't forget Compile VBAProject.
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
Posting Permissions
Reply With Quote
