Set text in text box based on value of selected cell?

**proepert** · 05-03-2010, 12:40 AM

Is it possible to set the text in a text box on a user form based on the value of the selected cell when the form is activated?

For example:
A1 has a value of 2.125

If A1 is selected when the form is activated, the text box in the form has 2.125

Thanks for helping me.

Excel 2000

**davesexcel** · 05-03-2010, 12:48 AM

Try This in the UserForm

Please Login or Register  to view this content.

**proepert** · 05-03-2010, 12:52 AM

Let me explain more, sorry.

No matter what cell is selected, I need that cell's value to go into the textbox.

It could be any cell on the current sheet.

Maybe a better question is "how do I find the address of the selected cell when the form is activated"?

**contaminated** · 05-03-2010, 01:33 AM

Maybe Like this???

**abrownin** · 05-03-2010, 01:52 AM

This will provide you with the value of whatever cell is selected at the time it runs across this line of code:

Please Login or Register  to view this content.

**proepert** · 05-03-2010, 02:35 AM

Thank you very much.

Set text in text box based on value of selected cell?

LinkBack

Thread Tools

Rate This Thread

Display

Set text in text box based on value of selected cell?

Re: Set text in text box based on value of selected cell?

Re: Set text in text box based on value of selected cell?

Re: Set text in text box based on value of selected cell?

Re: Set text in text box based on value of selected cell?

Re: Set text in text box based on value of selected cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions