ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Caption Property (https://www.excelbanter.com/excel-discussion-misc-queries/91589-caption-property.html)

the dude

Caption Property
 

Hi guys,
I'm building an UserForm and I have inserted a Combobox. In the
combobox property window, the caption property should allow me to
insert the data I would like to be displayed when clicking in the
combobox, but I really don't have a clue how to do that...
Anyone knows????
Thanks
The dude


--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=547367


Bob Phillips

Caption Property
 
With Combobox1
.Additem "first value"
.AddItem "second value"
'etc.
End With

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"the dude" wrote in
message ...

Hi guys,
I'm building an UserForm and I have inserted a Combobox. In the
combobox property window, the caption property should allow me to
insert the data I would like to be displayed when clicking in the
combobox, but I really don't have a clue how to do that...
Anyone knows????
Thanks
The dude


--
the dude
------------------------------------------------------------------------
the dude's Profile:

http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=547367





All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com