Textbox

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Hi all,

How do you get a textbox to autocomplete a word, or is it a textbox. I
have been using a combobox but I wanted to make the form a bit neater with
out the arrows.

Also

How can you change a caption of a userform to show the name in in cell a1
for example? I would love to have the userform show the name of the person
I am using the information about..

Thanks in advance

Greg
 
Hi Greg

can't help with the first Q ... personally, don't think combo boxes are that
messy :)

with Q2 use something along the lines of the following

Private Sub UserForm_Initialize()
UserForm1.Caption = Range("A1")
End Sub
 
Thanks Julie

I am being too fussywhen it comes to the userforms

Thanks for the help with the caption.

Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dateadd function question.. 0
Combobox selection 1
ComboBox problem 3
Excel Displaying content from excel sheet onto textbox in userform 0
Link a textbox on a sheet to a cell?! 2
Add Value from Textbox to next cell in range 2
TextBox on a userform - format to currency & percent 2
ComboBox linked to TextBox 4

Back
Top