Populate Userform from search box or scroll bar.

[D.A.S]

With great help from this Forum I have managed to create the attached Workbook with a Userform that populates with the first spreadsheet record when opened and which then allows new records to be created and/or updated ... Kudo's and much appreciation to Leith for his help with this.

What I would like to do now is to be able to make the first Textbox on the Userform (1) a dropdown Listbox that filled with the Contract Names in Column A on Sheet 1. The idea is that rather than spend ages going through all the records with the Spin Button, just so I could get to the record I wanted to update, I could just select a record from the dropdown Listbox that would then fill the other text boxes on the Userform (for altering/updating).

Alternatively, even browsing the records with a Scroll Bar may be faster than using the Spin Button, especially with having to chop and change from the first rows of records to the last ones, or having a search function whereby you could start typing a name into the first Textbox (top left) on the Userform and it would find a matching record and fill the form.

If I haven't completely confused everyone with the explanation above, I would be extremely grateful for any help you could provide.

PS. If playing with the attached, please feel free to tell me what I could have done better ... after all, we are supposed to learn by our mistakes !

If you are looking at this Leith ... check out the improved help form ... you might get another laugh !

[Leith Ross]

Hello Darryl,

Your Edit warning reminds me a humorous coffee mug I saw chiding FEMA (Federal Emergency Management Agency) evacuation plans. It read: "Run motherf***er, run!"

The ComboBox is a better approach than a TextBox. The ComboBox will, provided the data is alphabetical, scroll down to the entry you are looking as you type. You could use a second column to hold the row number of the record making it easier and faster to read and write the records. You could keep the spin buttons to allow the user to move through the records one at time. I will cobble something together for you then you can review it and tell me how bad it is and we'll start over.

[D.A.S]

Hi Leith,

That would be awesome if you could come up with something ... I spent most of the day trying different things, breaking it and then restoring from a backed up copy. I spend most of my days on construction sites as a Project Manager and only get to play with this in my own time usually (even though it is for the benefit of all in the office) hence I probably don't get there quire as fast as the folks that spend a lot of time working with excel or VBA.

On the plus side ... during my playing with it today I managed to add in a splash screen when it opens up (sample copy attached) ... I guess what I lack in programming skills I make up for with humour !

Thanks for the help and look forward to seeing what you cobble together.

Regards
Darryl

[D.A.S]

"Bump no response"

[D.A.S]

Hi Leith,

Have had several goes at getting the form to populate from a ComboBox as discussed but have to admit it is beyond my level of expertise (currently), so I eagerly await your expertise !

Regards
Darryl