Pre-input Existing data in sheet in textbox for VBA userform

[cannis]

hi there

I am preparing an user form via vba and would like to show the information (SNID) from sheet1 (SNID is in column A, there there are around 1000 items) to the textbox_SNID in user form.

Also i need to search the the SNID in the userform then i can input other items via the userform to sheet1.

I have no idea how to do it successfully, already had a few attempts.

thanks a lot!

[bakerman2]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Follow the directions in the yellow banner on top of the page.

[cannis]

so here is a sample...

For the useform, i wish that S/N: "1", SNID "155665" and "Andrew Bell" will appears on the input form textbox, and i can search other entries by their SNID.

For column Age and City, i will input them on the user form and the result will be shown on the sheet.

Thank you so much!

[torachan]

Attached the basics of an ADD/DELETE/UPDATE form, use the ListBox to search.
Using a Table to store your data means you do not have to keep checking for size as it expands/contracts as you Add or Delete.
Hope this helps you develop what you need, reading through the code should almost be self-explanatory.
torachan.

[cannis]

hi tora
thanks for helping. however, when ever i exit the userform, the excel sheet also closed and i cannot see the vba code by pressing alt + f11

i believe there is a way to just close the userform instead of closing the whole file.
also i wonder if i can search through the search table by using SPID?

thanks for the help to a new vba user.

[bakerman2]

Here you go.

[torachan]

@Bakerman, thanks, you are an early riser
Small error, no 'txtbox45', I have corrected in the attached.
Sorry I should not use close/save procedures when just demoing, left in from a previous coding, now removed.
torachan.