User-form, allow editing of cell value from textbox

Is there a property for a user-form textbox which allows editing of the cell associated with that textbox?

I am not getting exactly what do you want to do.
Do you want to use the textbox to edit a cell? To format it?

So I assume you have the value for your TextBox assign on the userform iniciate sub.

Just add the following code to the userform:

Please Login or Register  to view this content.

cmdAdd is the Command box you have to validate the change on the userform
TextBox1 is your text box

Hi Excel_&_Help,

Try in an Ordinary Code Module:

Please Login or Register  to view this content.

Try in the UserForm code module:

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

The detail of what I'm trying to do is on another post: Link
I have something similar to the line "Range("A3") = TextBox1.Value" in post #3 here. But it's giving me errors due to the additional complexities.
I was was hoping there was a single line property such as found here: Link

Hi Excel_&_Help,

I posted a reply in your other link. I will no longer respond to any posts in this link.

Link to your other post: https://www.excelforum.com/excel-pro...ml#post4805730

I agree with Andy that mixing Font properties are not available in UserForm controls. There is allegedly a lnkEdit control that may do what you want. You are on your own if you want to pursue the lnkEdit control.

Lewis