View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Returning The Column Number ?

Hi
use the column property of the range object.
e.g. if you store the range returned by the inputboy in the object
variable rng use
msgbox rng.column

--
Regards
Frank Kabel
Frankfurt, Germany

"MAS" schrieb im Newsbeitrag
...
Hi,

I am looking for the code or even just the vba function that will

return
with the column letter or number that a user clicks in, in response

to an
Inbox.

For example; When the input box comes up it prompts the user to

select the
cell they are interested in.

The user clicks on that cell and clicks on OK

I have no problem handling the value within the cell that was clicked

on but
what I want to read is the column that the person clicked in ?

MAS