User form retrieve data

Hi all! I am new to this so forgive the ignorance.

I've been playing with forms and I know that excel creates a user form from any row of data. it also retrieve the data using the find next command button on the form.

I've been reading some of the post to see if I can figure out how to do that on my form and quite frankly I get a little lost. So here is my post.

I created a user form with many fields in it. The form will be used at different times to insert different data. So I wanted to have the users of the form be able to retrieve the data at a later time so they could complete the form and then re-save it.

Since I don't know how to do that I don't really know what it is called. If you could direct me to some examples I would appreciate it much.

Hello DSJ,

When you refer to Excel creating a user form from any row, are you referring to the "Data Form" in the Data menu? Are you trying to create your own form using Visual Basic?

Sincerely,
Leith Ross

Yes that is what I am doing. I am using VBA to create the form and then run it from a command button.

Once I am done I plan on having the form open as the worksheet opens, that way users don't even have to look at the data elements behind it.

Hello DSJ,

I have attached a workbook I use as a both a template and training tool. This demonstrates how to construct a simple database using a workbook to store the data and a UserForm to manipulate the data. The UserForm opens when the workbook is loaded and a shortcut ALT+CTRL+R is added to run the form at anytime by the user. I am sure you can gain a few ideas from this. If youi have any questions, just ask.

Sincerely,
Leith Ross

Leith,

Thanks so much I think this will get me well on my way I do appreciate your time. If I need further help I will post again.

This was a big help but I was wondering if there was a way to use a combobox instead of the spinner control to select the desired record. I need to filter the records in the underlying spreadsheet where column A would represent my row number, column B contains the value to search, and column C contains the criteria where I want it to only display records where column C is blank. It would also be necessary to have the resulting values from column B displayed in the combo box in ascending order.