Refresh DropDownList - Select Orginal Option !

19 Mar 2006 12:15 PM

lovely_angel_for_you

Hi,

I have a drop down list on my VB form, from where I am entering the
data in Excel sheet. In the form a I have drop down list where the user
has to select an option and clickon "submit" to enter the data in
Excel.

Apart from dropdownlist, we have some textboxes as well.

Now after pressing [Submit], I wanted to clear the data entered earlier
in textboxes as well as dropdown lists.

Using text1.text = "", I was able to clear the textboxes. However with
what little knowledge I have, I am not able to refresh the dropdown
list, to go back to the original state where nothing is select from the
drop down options.

I have tried dropdown.refresh, didnt work.

Any ideas, how I can get that to work, will be appreciated.

Thanks & Regards
Lovely

19 Mar 2006 2:01 PM

DRBarkley

<lovely_angel_for_***@yahoo.com> wrote in message
Show quoteHide quote

news:1142770521.379652.177120@i40g2000cwc.googlegroups.com...
> Hi,
>
> I have a drop down list on my VB form, from where I am entering the
> data in Excel sheet. In the form a I have drop down list where the user
> has to select an option and clickon "submit" to enter the data in
> Excel.
>
> Apart from dropdownlist, we have some textboxes as well.
>
> Now after pressing [Submit], I wanted to clear the data entered earlier
> in textboxes as well as dropdown lists.
>
> Using text1.text = "", I was able to clear the textboxes. However with
> what little knowledge I have, I am not able to refresh the dropdown
> list, to go back to the original state where nothing is select from the
> drop down options.
>
> I have tried dropdown.refresh, didnt work.
>
> Any ideas, how I can get that to work, will be appreciated.
>
> Thanks & Regards
> Lovely
>

Combo1.ListIndex = -1

19 Mar 2006 2:50 PM

lovely_angel_for_you

Thanks a lot, DRBarkley !

Regards
Lovely