Run-time error 91 object variable or with block variable not set

JUST ME · #1 03-24-2014, 12:35 PM

Hello all,

I am having trouble with Run-time error 91, I created the code in a document by it self it worked fine. once i moved it over to my actual project it gives me the run-time error 91 and i have spend hours trying to determine why it works when it's the only code in a document but not when i put in in my project with all the other codes. the error occures on "userform1.show vbmodeless. does anyone have any suggestions?

Code:

Private Sub Document_Open()
Application.WindowState = wdWindowStateMinimize
UserForm1.Show vbModeless
End Sub

macropod · #2 03-24-2014, 03:02 PM

Have you moved the userform as well? If not, you'd probably need something like:
ActiveDocument.UserForm1.Show vbModeless

macropod · #3 03-24-2014, 04:29 PM

Cross-posted at: http://www.excelforum.com/word-progr...e-not-set.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

JUST ME · #4 03-25-2014, 06:56 AM

it was a cross post because there are 2 of us working on this project and I did not tell her I was posting for help. it was not done on purpose.

JUST ME · #5 03-25-2014, 06:56 AM

SOLVED: It was an error on my team mates part that made the error.
http://www.excelforum.com/word-programming-vba-macros/999121-run-time-error-91-object-variable-or-with-block-varialbe-not-set.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help sumif with variable for VBA	jingo	Excel Programming	4	01-23-2014 11:02 AM
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
XML parsing & Object variable not set (Error 91)	tinfanide	Excel Programming	0	12-29-2011 08:43 AM
Variable fields?	Emalee77	PowerPoint	0	01-30-2011 05:58 PM