Troubles with application.inputbox

[uffe]

I'm new to this, but there seems to a problem (may be me ;-).
Is there anybody out there that knows what's wrong?
Try the following (paste it in your VBA-editor window):
-----------------------------

Please Login or Register  to view this content.

'do I have to activate a sheet before I select cells on it?
'I thought maybe the select-method would call 'activate' implicitly?
'why can't I do worksheets("blad3").range(myRange.address).select without 'first activating "blad3"?

---------------------------
The goal would be to be able to select cells on any worksheet and make reference to those cells easily. But I found that neither the range-mode nor the string-mode of the application.inputbox-method solved it for me. I even tried with globals and events trying to catch the clicks from the user, but as you probably already know - the event workbook.sheetactivate isn't fired while making input to the application.inputbox. How would you solve this?

Thanks!
Uffe

[antoka05]

I think the easily way to fix your problem is to use a RefEdit component in a Userform.

Regards,
Antonio

[jasoncw]

Hi, Uffe. If you would like to keep the Application.InputBox, here is an alternative that finds the sheet name and range:

Please Login or Register  to view this content.

HTH

Jason

[uffe]

Hi, Uffe. If you would like to keep the Application.InputBox, here is an alternative that finds the sheet name and range:
HTH

Jason

Thanks Jason!

That really did the trick! Hats off!

Where can I find a REAL VBA language reference (all the objects and methods - the works)? I bought 'Excel 2003 Power Programming' by J. Walkenbach and 'Excel VBA macro programming' by Richard Shepherd, and though they are both quiet good books in their own special way, none of them is a language reference. Know where to prompt me?

Thanks again!
Uffe

[jasoncw]

Glad I could help, Uffe.

Sorry, I can't help with the book. The only references I have used are the 2003 Power Programming book and various online forums (and of course the Excel/VBA help menus).

Jason