Retrieving VLookup Values

[xander1987]

Hi there.

I'm creating an excel workbook and I want to create a macro which moves to the correct worksheet. It retrieves this correct worksheet from a VLookup formula, linked to a drop down box.

Example:

On the DataSheet the values are:

1 | Worksheet name
2 | Other worksheet name

and on the page with the macro and form the formula is =VLOOKUP(D2,DataSheet!B2:D5,2) (D2 is a drop down box from which the worksheets are chosen)

Any ideas how I can get VB to read the VLookup to get the worksheet name?

Thanks.

[xander1987]

Man I feel like a noob now. Sorry.

For future reference, it was the .Value I needed =/

It's been a while since I've worked with Macros so... yeah... that's my excuse =)