Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Control Box Problems
hi, I wish to link the result in a separate worksheet. Where should I put the code then?? Eg. Cell A2 in worksheet "Sheet2". In addition, instead of Row, can I link the results across columns instead?? How do I do that? Sorry, but I am code-illiterate. Thanks. ========================== Option Explicit Private Sub CommandButton1_Click() Dim iCtr As Long Dim oRow As Long oRow = 1 With Me.ListBox1 For iCtr = 0 To .ListCount - 1 If .Selected(iCtr) Then oRow = oRow + 1 Me.Cells(oRow, "A").Value = .List(iCtr) End If Next iCtr End With End Sub -- lu_meihua |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
calendar control - formatting | Excel Discussion (Misc queries) | |||
format control of a list box | Excel Worksheet Functions | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |