If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Textbox
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 |
#2
|
|||
|
|||
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 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Greg" wrote in message ... 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 |
#3
|
|||
|
|||
Thanks Julie
I am being too fussywhen it comes to the userforms Thanks for the help with the caption. Greg |
#4
|
|||
|
|||
you're welcome
"Greg" wrote in message ... Thanks Julie I am being too fussywhen it comes to the userforms Thanks for the help with the caption. Greg |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Textbox, web browser control, and Unicode (got cutoff) | Mark Johnson | General Discussion | 0 | February 12th, 2005 01:08 AM |
textbox to normal text | Jack Sons | New Users | 16 | December 5th, 2004 03:44 PM |
Problem formatting the border around a textbox on a report | Amit | Setting Up & Running Reports | 2 | October 24th, 2004 04:04 PM |
textbox used as report parameter | jh | Setting Up & Running Reports | 4 | October 21st, 2004 06:59 PM |
textbox formatting problem | jeffrey c | Powerpoint | 4 | August 21st, 2004 10:09 AM |