| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive spreadsheet column select
My macro opens a spreadsheet selected by GetOpenFileName. The macro then
needs to know which column of the spreadsheet contains the data it needs. The spreadsheets have no fixed format, so i would like the macro to open a message box telling the user to click in the column of the spreadsheet which has the data. 1) How can I code the macro to recognise the column from the user's mouse click? 2) What sort of message box will still allow the spreadsheet to be accessible? Grateful for help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a spreadsheet be saved as interactive webpage | New Users to Excel | |||
| Inserting an interactive spreadsheet into a webpage | Excel Discussion (Misc queries) | |||
| How do I make a spreadsheet interactive on a website? | Excel Discussion (Misc queries) | |||
| Publishing an interactive spreadsheet | Excel Programming | |||
| How to make a more interactive spreadsheet? | Excel Programming | |||
Threaded Mode
