F
Fred Holmes
I'd like to create a UserForm to be used as a "reader" for the active
cell. I have created UserForm1 with two text boxes on it, with the
following code:
Private Sub UserForm_Initialize()
TextBox1.text = ActiveCell.Value
TextBox2.Text = ActiveCell.Formula
End Sub
But when the UserForm is shown, it has the focus, and the focus is in
text box 1. I want to keep the focus on the worksheet, and edit and
use the WorkSheet in the "usual" manner, with the UserForm only
showing the contents of the ActiveCell actively.
And once the above is accomplished, the Userform must update
automatically with change in the active cell -- either content or
location.
How might this be done?
TIA
Fred Holmes
The font/typface in the text boxes will be larger.
The text boxes will wrap text multiline in order to show verbose
content fully.
The text boxes will be wider (characterwise) than the column width of
the active cell, in many instances.
The text boxes may perform additional functions, as I get ideas. Or I
could add other objects to the UserForm.
The worksheet formula editing bar does some of the above, but it
doesn't magnify the text. The userform can be put anywhere, while the
formula editing bar will expand to block the view of the top line on
the worksheet.
cell. I have created UserForm1 with two text boxes on it, with the
following code:
Private Sub UserForm_Initialize()
TextBox1.text = ActiveCell.Value
TextBox2.Text = ActiveCell.Formula
End Sub
But when the UserForm is shown, it has the focus, and the focus is in
text box 1. I want to keep the focus on the worksheet, and edit and
use the WorkSheet in the "usual" manner, with the UserForm only
showing the contents of the ActiveCell actively.
And once the above is accomplished, the Userform must update
automatically with change in the active cell -- either content or
location.
How might this be done?
TIA
Fred Holmes
The font/typface in the text boxes will be larger.
The text boxes will wrap text multiline in order to show verbose
content fully.
The text boxes will be wider (characterwise) than the column width of
the active cell, in many instances.
The text boxes may perform additional functions, as I get ideas. Or I
could add other objects to the UserForm.
The worksheet formula editing bar does some of the above, but it
doesn't magnify the text. The userform can be put anywhere, while the
formula editing bar will expand to block the view of the top line on
the worksheet.