TextBox.
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: TextBox.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    In column 'C' of my spreadsheet I have comments from variuos people which must be quoted in full upwards of 1000 charaters. I have inserted a UserForm with a TextBox on it with its source pointing at the first of my list in column 'C' (ie source box =C3). What code do I need so that when the user uses an arrow (direction) key to go down or up to the next cell, the UserForm refreshes with the appropriate cell reference from column 'C' ?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-15 00:06, Nigel Martin wrote:
    In column 'C' of my spreadsheet I have comments from variuos people which must be quoted in full upwards of 1000 charaters. I have inserted a UserForm with a TextBox on it with its source pointing at the first of my list in column 'C' (ie source box =C3). What code do I need so that when the user uses an arrow (direction) key to go down or up to the next cell, the UserForm refreshes with the appropriate cell reference from column 'C' ?
    Hi Nigel you could use the worksheets change
    event to update the userorms checkbox eg
    In the relevant sheet


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 3 And UserForm1.Visible = True Then
    UserForm1.TextBox1.Text = Target.Text
    End If
    End Sub

    Note, I'm assuming your UFrm is showmodal=false
    and you are selecting the cells via key input change by the user.


    Kind Regards,
    Ivan F Moala From the City of Sails

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com