Command button caption to show what is selected in the listbox.

[danbates]

Hi,

Please can someone help me?

I would like my commandbutton1 caption to show what is selected in my listbox1.

Any help would be appreciated.

Thanks

Dan

 

[James006]

Hi,

Your description is very vague ...

There are several questions one would like to ask ...

Can the following be of any help :

CommandButton1.Caption = ListBox1.Selected(0)

 

[Domenic]

Assuming that your listbox allows only a single selection, try...

    With Me.ListBox1
        Me.CommandButton1.Caption = .List(.ListIndex)
    End With

Note, you should check to make sure that a selection from the listbox has been made before trying to set the caption for the commandbutton. When no selection is made, ListIndex is equal to -1, so you can test as follows...

If Me.ListBox1.ListIndex <> -1 Then

Hope this helps!

 

[danbates]

Hi,

James006 - Sorry I was vague in my description. Your code shows 'false' on my command button when I make a selection from my listbox.

Domenic - Your code works just how I wanted, thanks.

Thank you both for taking time to help me out.

Regards

Dan

 

[Domenic]

You're very welcome, cheers!