Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Material for setting values for Form Controls using VBA
CAn anyone point me to a good reference site/material on the different form
controls (Listbox, group box, label, etc) and how to set those properties (such as setting the text, color) using VBA? Was trying to navigate through microsoft's help online, but is quite cumbersome. Any help would be appreciate. thanks, Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Material for setting values for Form Controls using VBA
What I did was just place an object on a form and then down in the lower
left-hand area of my screen was a properties box. The properties can be viewed categorized or alphabetcal. Experiment with changing them to learn what they do. To put code, right-click the object and select view-code. Then put code in and see what happens. That is how I've learned it. "Chris" wrote: CAn anyone point me to a good reference site/material on the different form controls (Listbox, group box, label, etc) and how to set those properties (such as setting the text, color) using VBA? Was trying to navigate through microsoft's help online, but is quite cumbersome. Any help would be appreciate. thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to access or copy excel form controls (eg. dropdownlist) values to a database | Excel Programming | |||
Form Controls; setting properties based on cell values | Excel Programming | |||
InitializeComponent() errors, Setting values in another form | Excel Programming | |||
Setting form controls focus and enter key | Excel Programming | |||
Accessing the values of form controls on worksheets in Excel 2000 | Excel Programming |