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

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
>

try something like that:

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


"Gig" <(E-Mail Removed)> a écrit dans le message de
news:a0091b62-c755-4583-8669-(E-Mail Removed)...
> 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