ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Resetting Combo Boxes (https://www.excelbanter.com/excel-programming/301972-resetting-combo-boxes.html)

Stan

Resetting Combo Boxes
 
Hi all,

Sorry for what is a very simple question, but:

I want to reset the value of a combo box to the initial value given in its source list.
How would I do this assuming the list range is called "Parts", and is based on the click of a button?

Thanks
Stan

Bob Phillips[_6_]

Resetting Combo Boxes
 
Combobox.ListIndex=0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stan" wrote in message
...
Hi all,

Sorry for what is a very simple question, but:

I want to reset the value of a combo box to the initial value given in its

source list.
How would I do this assuming the list range is called "Parts", and is

based on the click of a button?

Thanks
Stan





All times are GMT +1. The time now is 03:34 AM.

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