Visual Basic Help

Status
Not open for further replies.

Death Row

In Runtime
Messages
128
I'm making a system about calculating energy usage, for my ICT project, but I've gotten hopelessly stuck on one aspect.

In order to make the project as user friendly as possible, I said they could retrieve data with macros - I've discovered however that this is rather difficult.

So, it works like this
On one sheet, there's a list box, with a load of table names, the user selects a name, and presses a macro button that looks up the table, copies the information, and pastes it onto the current worksheet.

My problem is writing the macro to look up the appropriate table.

I worked out, that the code to looking up a table was
Code:
Application.Goto Reference:="_29_03_2011"
and I thought i could simply change the table name in the code to RefersToG12
Code:
Application.Goto Reference:=RefersToG12

It simply says the reference is invalid, and I'm utterly confused as to what to do.
Any help would be greatly appreciated.
 
I've just thought of a much better way of rephrasing the previous post

In the formula bar in excel, there's a drop down menu, which shows all the named ranges
I just want to implement this drop down menu into a worksheet/Visual Basic Form for the user to use.

I'm pretty sure this is possible with some clever visual basic coding, but if it isn't, please tell me!

Thanls again
 
Status
Not open for further replies.
Back
Top Bottom