ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cell value from text box (https://www.excelbanter.com/excel-programming/320639-cell-value-text-box.html)

MrHappy

cell value from text box
 
I know I can to a text box with a cell link, but can a person do a cell with
a textbox link...in the normal worksheet no vba...not yet that is :)
Tim

Sharad Naik

cell value from text box
 
It anyhows works bothways
If a text box as LinckedCell = A1
If you type in Textbox A1 will change accordingly.
If you type in A1, TextBox text will change accordingly.

So what's that it is in your mind?

Sharad

"MrHappy" wrote in message
...
I know I can to a text box with a cell link, but can a person do a cell
with
a textbox link...in the normal worksheet no vba...not yet that is :)
Tim




MrHappy

cell value from text box
 
Can you get Cell A1 to read what is put in a text box 1 Sharad?

Thanks for you response!

Tim




"Sharad Naik" wrote:

It anyhows works bothways
If a text box as LinckedCell = A1
If you type in Textbox A1 will change accordingly.
If you type in A1, TextBox text will change accordingly.

So what's that it is in your mind?

Sharad

"MrHappy" wrote in message
...
I know I can to a text box with a cell link, but can a person do a cell
with
a textbox link...in the normal worksheet no vba...not yet that is :)
Tim





Sharad Naik

cell value from text box
 
Of course!
And also Textbox to read what is put in A1
I mean you manually change A1, and Textbox will follow it.
You manually change Textbox and A1 will follow it.

Now what version of excel are you using?

Sharad

"MrHappy" wrote in message
...
Can you get Cell A1 to read what is put in a text box 1 Sharad?

Thanks for you response!

Tim




"Sharad Naik" wrote:

It anyhows works bothways
If a text box as LinckedCell = A1
If you type in Textbox A1 will change accordingly.
If you type in A1, TextBox text will change accordingly.

So what's that it is in your mind?

Sharad

"MrHappy" wrote in message
...
I know I can to a text box with a cell link, but can a person do a cell
with
a textbox link...in the normal worksheet no vba...not yet that is :)
Tim








All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com