LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAS MAS is offline
external usenet poster
 
Posts: 18
Default InputBox: Display Cell Content not Cell Ref ?

Hi,

Could someone please clarify for me.

I have some code that brings up an InputBox at which point I click on the
appropriate cell, in this case a column of names, but rather than the name
appearing in the InputBox, I see the Cell reference i.e. $B$1.

I then click on OK and process the name in the code as I planned.

What I want to know is if there is a way to get the contents of the selected
Cell to show in the InputBox rather than the cell ref ?

If there is I will bet its something really simple that I have missed, but I
have conceded defeat ;-)

MAS



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to display my cursor cell content in another cell.... dh13134 Excel Worksheet Functions 3 May 12th 09 10:43 PM
Display the content of one cell over next cell margoul1 Excel Discussion (Misc queries) 1 August 5th 08 09:18 AM
Why does my cell content display as '############'? Mark Excel Discussion (Misc queries) 4 July 22nd 08 07:07 PM
restrict cell content display Stefi Excel Discussion (Misc queries) 3 December 6th 07 02:07 PM
How to click on a cell and have the content of the cell display in a different cell [email protected] Excel Worksheet Functions 0 June 6th 06 03:05 PM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"