Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How To align (set tabs or columns) on a text string
Hello The following code Quote Set AADrpDn = .Shapes.AddFormControl(xlDropDown, 4, 84 + 33, 536, 21) For i = 1 To 10 TextF = Cells(i, 2) & Cells(i, 3) & Cells(i, 4) & Cells(i, 5) & Cells(i, 6) AADrpDn.ControlFormat.AddItem TextF Next i Unquote is in a excel macro, which working as follows: 1st...- eoaapp
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
DropDown List Return Selected Item using VBA
I use the following code >>Sub TESTA() >>With Worksheets(1) >>Set k = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100) >> For x = 1 To 10 >> k.ControlFormat.AddItem "test" & x >> Next >>End With >>End Sub wich produce a drop dawn list (test1, test2, ...,test10). I need help to...- eoaapp
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
