Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine row where activex control is placed
hi all,
i m creating dynamic list boxes in excel sheet. now on the selection of the item of the list box i want to pouplate cells in the same row. how can i do it? jigs D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine row where activex control is placed
Here's one way:
Dim LBox As OLEObject Set LBox = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ListB ox.1", Link:=False, _ DisplayAsIcon:=False, Left:=278.25, Top:=283.5, Width:=117, Height:= 33) MsgBox LBox.TopLeftCell.Address NickHK "jigs d" wrote in message ... hi all, i m creating dynamic list boxes in excel sheet. now on the selection of the item of the list box i want to pouplate cells in the same row. how can i do it? jigs D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Help with using an activex control | Excel Programming | |||
How to control "Date Time Picker ActiveX Control" | Excel Programming | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) | |||
ActiveX Control | Excel Programming |