LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default VBA code for Userform

I want to create a Userform with Excel 97 that includes:
- 1 combobox cmdDay indicating Day (1-31)
- 1 combobox cmbMonth indicating Month (Ene-Dic) (=
Spanish format!)
- 1 checkbox indicating whether I should include a
directory
- 1 checkbox indicating whether I should include another
directory.
-1 textbox which should represent selection of combox
cmdDay
-1 textbox which should represent selection of combox
cmdMonth

Questions:

1) Can anybody provide sample code to get Combobox
cmbMonth filled with name of months?

Should be similar to:
With cmbDay
For i = 1 To 31
.AddItem (i)
Next
End With

2) What VBA code gets selection of combobox into the
textbox? (ie. textBox.Text = cmbMonth.Value?)

3) If I create Userform with names and then try executing
code, what means error "Variable not defined"?

Thanks in advance,

Martin

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NEED A MACRO CODE TO USE IN A USERFORM Rachel Excel Discussion (Misc queries) 3 November 25th 08 10:08 AM
Re-show userform after closing file - code help Gerry O Excel Discussion (Misc queries) 3 September 4th 07 10:52 PM
Code to edit directly in cells from userform Tom Ogilvy Excel Programming 0 September 7th 03 10:27 PM
Code to edit directly in cells from userform Harald Staff[_4_] Excel Programming 0 September 7th 03 10:09 PM
Control code behavior with userform ? steve Excel Programming 0 July 30th 03 05:01 PM


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"