Combo Box/Drop down box

Y

Yog

I know i'm being really dumb here, but i need someone to point out the
obvious to me!!

I am trying to use a combo box where the user selects an option from the box
and is taken to a webpage/document depending on the selection made. The data
range is not very big at all and at the moment is in a column on the very
same sheet, i.e. A12:A23.

I have tried the combo box from the forms toolbar and am fine with the data
range but am having problems when it comes to the VBA. Especially when i am
trying to determine the selection that has been made. I am unable to find the
variable that refers to 'what option has been selected'. I have also tried
using the cell link property but VB does not seem to like #if
Range("b12").value, stating that 'variable not defined'

I then tried the combo box from the control toolbox, but the problem i am
having there is specifying the data range which the combo box refers to.

I am presuming that after this it will be a matter of using the VBA 'Select'
command.

Thanks in advance
 
D

Dave Peterson

I think using data|validation is the easiest way to implement this kind of
dropdown.

Debra Dalgleish has some very nice instructions here:
http://contextures.com/xlDataVal01.html

Then I would add a button from the Forms toolbar that would have a macro
assigned to it.

Option Explicit
Sub testme()

Dim myCell As Range

Set myCell = ActiveSheet.Range("A1") '<-- change the address here.

If IsEmpty(myCell.Value) Then
Beep
Exit Sub 'nothing in the cell
End If

ThisWorkbook.FollowHyperlink myCell.Value
'or maybe...
'ThisWorkbook.FollowHyperlink "Http:\\" & myCell.Value

End Sub

If you decide to use a dropdown from the Forms toolbar or a combobox from the
control toolbox toolbar, you could have code that does the same kind of thing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top