PDA

View Full Version : Solved: userform error 424



jazznaura
04-26-2008, 10:29 AM
Hi all,

I?m having problems trying to get a userform to show. I keep getting a 424 error, object required. I can't figure out what I?m doing wrong, why it doesn?t know where the userform is. How do I tell it where to look?

Please help; this is only my second attempt at using userforms. i've attached workbook.

Thanks,

tpoynton
04-26-2008, 10:40 AM
it's the picture; i recall having trouble inserting a picture. my solution was to use the controls toolbox to insert a picture, instead of trying to set the picture property of the userform itself.

Simon Lloyd
04-26-2008, 10:44 AM
Just a simple typo!

TextBox1 = sheets1.Range("Q2").Value
should read:

TextBox1 = sheet1.Range("Q2").Value
so change all sheets1 to sheet1.

jazznaura
04-26-2008, 10:50 AM
picture? do you mean the userform background image? if so i tried that and still no luck.

jazznaura
04-26-2008, 10:52 AM
thanks simon, just could'nt see it.

Simon Lloyd
04-26-2008, 11:48 AM
Your welcome glad you're sorted!