Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list box
I have a list of items in a worksheet. The worksheet uses this list via
validation to allow to have a drop down menu in some of the cells. I also have a userform that uses this list to populate a listbox. When I open the userform I have coding that allows me to select an item on the worksheet using the listbox. The problem is when I close the userform and want to use the worksheet validation cells to select an item excel jumps to the start of the validation list. Here is the code for the list box: Private Sub CommandButton1_Click() With activeworksheet ActiveCell.Select ActiveCell.Offset(0, 5).Select If ActiveCell = "Yes" Then ActiveCell.Offset(0, -1).Select ActiveCell.ClearContents Else MsgBox "Cannot Reset" End If End With End Sub Private Sub CommandButton2_Click() UserForm1.Hide End Sub Private Sub ListBox1_Click() With activeworksheet Range("Part")(UserForm1.ListBox1.ListIndex + 1).Select End With End Sub Commandbutton2 closes the form Commandbutton1 resets some information Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
list box
Not sure what you mean, do you mean data validation doesn't update? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
list box
Its ok i figured it out.
"D." wrote: Not sure what you mean, do you mean data validation doesn't update? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |