Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving cell values from sheet2 to sheet1 using UserForms and ListBox
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
jump to cell in sheet2 when values in sheet1 is true | Excel Discussion (Misc queries) | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Moving from 1 row sheet1 to sheet2 | Excel Worksheet Functions | |||
How to set sheet1!cell = sheet2!samecell and set format? | Excel Programming |