Create an Excel UserForm, Part 3 of 3

http://www.contextures.com/xlUserForm01.html
Create an Excel UserForm, add code and test the form. There is a sample file on the website (link shown above) that you can download for testing.

Category:

Science & Technology

Tags:

• Excel
• UserForm
• Contextures
• VBA

[MsNena2507]

I created one, I want to manage my supply inventory, Please Help!!!

when i ran it, it said subscript range error!!!!

[contextures]

@MsNena2507 If you are using different sheet names than in the sample file, you will have to change those names in the code.

[cspanjunkie101]

This is a great tutorial! But I didn't see where to add this code from the website to test out. Any way to give us the link?

[contextures]

@cspanjunkie101 On the Contextures website page (link in the video description above), there is a link for a sample file with the code in it. Download that, and it might help you see where to add the code in your file.

[TheLalli88]

i got the the message at the time of clicking 'Run Sub/Userform' that "Macros in this project are disabled".. how can enable the macros, i didnt get it??? plz helpppp!!!!

[contextures]

@TheLalli88 In Excel 2007: On the Ribbon, click the Developer tab, and in the Code group, click Macro Security. In the Macro Settings category, under Macro Settings, click Disable all macros with notification Click OK. If you changed the setting, close the workbook, and then reopen it.

Then, when you open the workbook, enable the macros.

[Mysteryman2402]

This is genious! Thanks!

[DrummerGnR]

Everything works fine thanks a lot but one thing. It enters the data at the next empty coloumn, but i need it to enter the data in columns that already have data further along in them. Is there any way to do this?

Thanks again

[5kplamse]

When you paste the code, where are you pasting it from? Sorry for my ignorance :(

[AliceAsya]

@AliceAsya fixed it, now Subscript out of range?

[AliceAsya]

Compile error: Method or data member not found?