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