+ Reply to Thread
Results 1 to 6 of 6

Default wording in Textbox

  1. #1
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Default wording in Textbox

    Hi there,

    I have two TextBox items in my worksheet.

    Is there a way I can have specific wording always appear in the text box but when you click on it to type, the wording disappears?

    Thanks

  2. #2
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,818

    Re: Default wording in Textbox

    Maybe :
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Re: Default wording in Textbox

    Hi Karedog,

    Thats exactly what I want, however, I don't actually have the textbox's in a userform. The textbox is just inserted onto the worksheet. I can't upload unfortunately due to the sensitive information in the file.

    Basically its an ActiveX TextBox (TextBox21 and TextBox22). Both are linked to separate cells on the spreadsheet.

    I don't need any special coloured backgrounds or font sizes. I just want the following to appear:

    TextBox21 to say "Enter Department / Recipient Name Here..."
    TextBox22 to say "Enter Previous / Maiden Name Here..."

    I'm not great with codes myself, so I'm not entirely sure what to remove from the great code you provided to me above.

  4. #4
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,818

    Re: Default wording in Textbox

    Maybe like this one ?
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Re: Default wording in Textbox

    That's fantastic, thanks so much Karedog!

  6. #6
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,818

    Re: Default wording in Textbox

    You are welcome Anarchus, thanks for marking the thread as solved.


    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to Clear default value from Textbox on click?
    By priya06manohar@gmail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 08:30 PM
  2. [SOLVED] If statement if cell x is <12 add this wording, if cell y is =>12 add this wording
    By Triscia in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-06-2013, 01:41 PM
  3. Change wording for a default excel message
    By betboy25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2012, 02:53 PM
  4. Replies: 6
    Last Post: 02-17-2012, 04:23 AM
  5. Default Date in TextBox
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-09-2011, 03:27 PM
  6. How to specify non-default date format for a textbox
    By lottesfog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2007, 12:10 AM
  7. Default values in textbox
    By drifter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2006, 07:10 AM
  8. Default in a textbox and change a module name
    By filo666 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2005, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1