learningthings
New Member
- Joined
- Oct 29, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Each row in the database is assigned a unique ID number (5 digits long)
I want to be able to enter than ID number in a textbox in a userform and have the row information (4 columns total) displayed in a listbox.
I want the listbox to update after each 5 digit long ID number entry so I can keep inputting values into the textbox without hitting any buttons.
Next, I have a button named save. If I hit it, it moves all of the rows of data from the database worksheet (that are in the listbox) to another one (Sheet2). And those rows are deleted from the database worksheet.
How could I code this?
If anyone needs more info on this please let me know. I don't know how much detail to go into since this is my first post on this forum.
Thank you so much!
I want to be able to enter than ID number in a textbox in a userform and have the row information (4 columns total) displayed in a listbox.
I want the listbox to update after each 5 digit long ID number entry so I can keep inputting values into the textbox without hitting any buttons.
Next, I have a button named save. If I hit it, it moves all of the rows of data from the database worksheet (that are in the listbox) to another one (Sheet2). And those rows are deleted from the database worksheet.
How could I code this?
If anyone needs more info on this please let me know. I don't know how much detail to go into since this is my first post on this forum.
Thank you so much!
