How to determine what Cell was selected

[chamdan]

Help needed,

Can anyone help me in finding how to write the command in VBA to determine what Cell was selected in a worksheet? The objective is to know what Cell has been selected by double click event to pop up a userform with a calendar from which the user can select the date. I am looking at making it dynamic so I do not select a particular range.

Can this be achieved? I guess yes, but how?

Looking forward for your feedback.

Appreciate your help.

[DonkeyOte]

See the Worksheet_BeforeDoubleClick event which passes the double-clicked cell as Range (Target).

[Andy Pope]

right click sheet tab and view code.
paste the following

Please Login or Register  to view this content.

[chamdan]

Appreciate your prompt reply .

I have tried this but it is not working. Is there something wrong?

Please Login or Register  to view this content.

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here


Why are you trying to assign the target to a range reference?

Just use the Target object

[chamdan]

Please Login or Register  to view this content.

I tried this but did not work too. Sorry but I am not a VBA expert just a beginner.

Would appreciate if you can provide me with the command line that would resolve my issue?

Thanks for your tip.

[Andy Pope]

Please Login or Register  to view this content.

You have not explained why you are doing this though.

When userform1 shows what variable will it be trying to use?

[chamdan]

Thanks Andy,

The objective is to select a date from the calendar and the date will be placed in the appropriate targeted cell.

Please Login or Register  to view this content.

This worked exactly the way I wanted.


Cheers!

[Jack in the UK]

this will cover teh calanda bit for you

Go to Tools / Macro / VBE
Go to Insert / UserForm from within the VBE.
Open Control Toolbox, if not go to View / Toolbox etc
Right click on the Toolbox and select Additional Controls
Find Calendar Control 10.0 and check the checkbox and click OK
Select the UserForm go to View / Properties Window
Select Caption from the Properties Window and replace:
UserForm1 with the word Calendar (This is critical)
Go to View / Code add the code exactly as show below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Go to Insert / Module and in a new module copy this code

Please Login or Register  to view this content.

[DonkeyOte]

Remember however that the Calendar control is not always available by default.

chamdan, you have still not corrected your code tags from earlier (missing) - please edit your post accordingly.

No further posts until actioned, thanks.

D.O.