Solved: userform error 424

[jazznaura]

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]

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]

Just a simple typo!
[VBA]
TextBox1 = sheets1.Range("Q2").Value
[/VBA]should read:
[VBA]
TextBox1 = sheet1.Range("Q2").Value
[/VBA]so change all sheets1 to sheet1.

[jazznaura]

picture? do you mean the userform background image? if so i tried that and still no luck.

[jazznaura]

thanks simon, just could'nt see it.

[Simon Lloyd]

Your welcome glad you're sorted!