User Form To Populate New Row?

DerekK

Board Regular
Joined
Jun 18, 2007
Messages
84
Kind coders,

I am developing a user form for a shared workbook in order to standardize row entries from multiple users.

Ideally, when a user needs to make an entry into the workbook, the user would click on a button, the user form would pop up and the user would populate the various required information; and the new entry would create a new row below the previous row entry.

My first question is, if there are multiple users for this shared workbook, is there a way to reserve a line for a new row/entry as a user completes the user form? In other words, if there are two (or more) users trying to make an entry at roughly the same time, is there a way to ensure the same row is not used for two (or more) entries?

Secondly, can I put all "blanks" to be completed on one single user form (i.e., name, account number, address, etc.) or would I need a separate user form for each blank?

Lastly, is there a good resource for creating user forms? Because I am presently just using the automatic 'help' function within the VBA screen and I'm kind of struggling.

Hope you can help,



Derek
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

DerekK

Board Regular
Joined
Jun 18, 2007
Messages
84
Actually, that looks like it will answer my other questions, as well.

Thanks, Daddy-O, and g'day!
 

Watch MrExcel Video

Forum statistics

Threads
1,126,939
Messages
5,621,716
Members
415,853
Latest member
Newlife72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top