Moving cell values from sheet2 to sheet1 using UserForms and ListBox

S

Stein Kristiansen

Some questions from a novice user.

Here is the task:

I have a workbook with two spreadsheets. Sheet2, column A consist of x cells
of unique serial numbers.
From Sheet1 the user should select an empty cell in column A, then click a
button that starts the UserForm. The UserForm should have a ListBox
populated with the unique serial numbers from Sheet2.
By selecting one serial number (and clicking the OK button in the userForm),
that number should be pasted in to the cell that was active when the
UserForm was activated and the unique serial number should be removed from
Sheet2.

Questions:
- How do you fill up the list box whit the values from Sheet2 when you don't
know the numbers of cells used?
- How do you paste the number chosen into the active cell of Sheet1?
- How do you delete the chosen number from Sheet2?

Any help is appreciated.

Regards
Stein Kristiansen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top