Combobox Dropbutton click event
 

I'm trying to set the rowsource of a combobox when the drop down
button is clicked. It looks to be working fine, then I get an error
message from Excel saying that it has encountered a problem and must
shut down.

I stepped through the code with the debug feature and there is
definitely something wrong, but I've not been able to figure it out.
This is the code.

Private Sub ComboBox6_DropButtonClick()
ComboBox6.RowSource = "h_outermagnetbore"
End Sub

h_outermagnetbore is a range

When I click on the drop button, the selections are there, but then
the error statement comes up immediately and I must shut down Excel. I
can probably figure out some other way, but it seems like this should
work. Can anyone tell me why it won't work?

Thanks,
Greg

Combobox Dropbutton click event
 

If the source is a range with the name h_outer ... , then why is it in
quotation marks?

"Gig" wrote:

I'm trying to set the rowsource of a combobox when the drop down
button is clicked. It looks to be working fine, then I get an error
message from Excel saying that it has encountered a problem and must
shut down.

I stepped through the code with the debug feature and there is
definitely something wrong, but I've not been able to figure it out.
This is the code.

Private Sub ComboBox6_DropButtonClick()
ComboBox6.RowSource = "h_outermagnetbore"
End Sub

h_outermagnetbore is a range

When I click on the drop button, the selections are there, but then
the error statement comes up immediately and I must shut down Excel. I
can probably figure out some other way, but it seems like this should
work. Can anyone tell me why it won't work?

Thanks,
Greg

Combobox Dropbutton click event
 

try something like that:

Private Sub ComboBox6_DropButtonClick()
ComboBox6.Rowsource = Application.Transpose(Range(h_outermagnetbore))
End Sub


"Gig" a écrit dans le message de
...
I'm trying to set the rowsource of a combobox when the drop down
button is clicked. It looks to be working fine, then I get an error
message from Excel saying that it has encountered a problem and must
shut down.

I stepped through the code with the debug feature and there is
definitely something wrong, but I've not been able to figure it out.
This is the code.

Private Sub ComboBox6_DropButtonClick()
ComboBox6.RowSource = "h_outermagnetbore"
End Sub

h_outermagnetbore is a range

When I click on the drop button, the selections are there, but then
the error statement comes up immediately and I must shut down Excel. I
can probably figure out some other way, but it seems like this should
work. Can anyone tell me why it won't work?

Thanks,
Greg

--
Michel Angelosanto, Bordeaux
Dernières mises à jour du site Voyage au pays Internet
http://angelosa.free.fr/index.php?t=8