Solved: VB Editor

[bopo]

Hi

Okay, this is my first time creating a system using VBA, anyway I opened up the VBE editor, made a background image, got everything perfect, and then realised 'where are the text boxes' now I am really, really confused, as will was suppost to be a login form.


So does this mean I have to create everything in spreadsheets, and im guessing background images cant be applied or anything, please help :(

[XLGibbs]

Sounds like you inserted a userform in the VB window, assigned text boxes etc, but went back to the sheet and didn't see it?

You need to have something tell the form to load.

If you go to the ThisWorkbook module within your workbook, you can type this in the Workbook_Open() event

UserForm1.Show

(Where UserForm1 is the name of the form)

Or you can place a button on the worksheet, and assign that code to open the form. See attached.

[bopo]

Ahhh, I see what you mean, thanks