• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Open list when cell in column gets focus, append term from list to text

mdavid

Member
Hi, I have columns that contain text, each column has a list of terms that are related to the text in the cells of that column.
What I would like/need your help to do is:
1. When a cell in one of the columns gets focus a list of the relevant terms for that column will open - and remain open till a cell in another column gets focus.
2. When the user enters text in the cell he can click a term in the list and it will be appended to the text.

Any vba snippets or relevant links much appreciated
Thanks
David
 
Upload sample workbook. Without examples that accurately represent your actual data set. It's hard to give you right fit solution.
 
What i want to do is have a list open while I'm entering text into the cell and I can select a term from the list which will be added at the cursor position, so I have this code that opens a userform when I click in the cell:
Code:
Dim ws As Worksheet:    Set ws = ThisWorkbook.Worksheets("Complaints")
    Dim myCell As Range:    Set myCell = ws.Range("F2:F1321")
    Dim iSect As Range
    Set iSect = Application.Intersect(Target, myCell)
    'If the selection is not your cell, exit sub
    If iSect Is Nothing Then Exit Sub
    UserForm2.Show

but the focus now moves to the list in the userform, I need the focus to return to the cell so I can enter text and just select terms from the list as needed.
Any ideas?
 
I understand that I need to open the userform like
Code:
UserForm4.Show vbModeless
This will open the list but it won't grab the focus I can continue entering text and the list stays open now I need to work out how to insert clicked terms from the list into the text - any ideas?

Thanks
David
 
Back
Top