Finding cell that a user click?

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

Is the event Worksheet_SelectionChange(ByVal Target As Range) the only way
to detect which particular cell a user has clicked?
 
Hi
if you want an automatic response directly after the
selection change, then yes. If you want the current
selected cell within a mayro you can always use
msgbox activecell.address

But maybe you can explain what you're trying to do and why
the worksheet_event won't work for you :-)
 
When a user select a certain range of cell, the date and time picker will
appear. But somehow, the size of the Date and Time Picker did not appear
correctly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Returned position address on protected sheet 7
Address of Selection Prior to Clicking on a Cell 1
Cell Address & VLOOKUP in VBA 4
userform and events 5
Need Syntax for "AND" to Evaluate 2 Cells 4
Control of cell comments lsot in Office10 1
Change cell font color when cell is clicked 9

Back
Top