Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an add-in that dynamically creates various kinds of OLE controls on a
worksheet. I use code like the following: ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.1", ... ActiveSheet.OLEObjects.Add(ClassType:="Forms.Combo Box.1", ... I need to use OLE objects rather than say Form controls (which at least in the case of combo boxes look a little better) because I need the events exposed by the OLE objects. Anyway, all of this works fine and has been stabile for years. Buy my users increasingly complain about the aesthetics of these controls. Without being to precise, I think the above code results in Windows 3.1 controls being created (OK, maybe its Win95) and they just look like old clunkers. I'm looking for a way to create contemporary WinXP (or perhaps even Vista) controls on my worksheets. I need command buttons, combo-boxes, text-boxes, list-box, option button and check-box controls. Installing a new dll or ocx onto my user's systems to make this happen would be OK. Anybody got any bright ideas? TIA, josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = Fals | Excel Programming | |||
Activating Worksheet Controls - "Excel VBA Problem" | Excel Programming | |||
Can ActiveX controls be "disabled" and "enabled"? | Excel Programming |