+ Reply to Thread
Results 1 to 2 of 2

Replacing specific text in multiple text boxes based on cell values

  1. #1
    Registered User
    Join Date
    08-17-2017
    Location
    Las Vegas, NV, USA
    MS-Off Ver
    2016
    Posts
    1

    Replacing specific text in multiple text boxes based on cell values

    Hello,

    I am trying to accomplish three things:

    1. I need to replace specific numbers in a text box based to match the values of a specific cell.
    2. I need to replace a section of text, using a rule that will determine the text based on the value of a specific cell.
    3. Bold the values that change (the numbers and the section of text).

    All of the changes are in the same text box. For example, the text box contains the following text:

    Jane Doe has completed a total of 53 research hours since August 1st, 2017. Based on the number of hours worked, I recommend she work additional hours a week in order to stay on track.



    Cell A1 = Jane Doe (researcher's name)
    Cell B10: = 53 (the total number of hours worked)
    "Work Additional" would change based on the value of cell B10.
    For example:
    B10 < 55, then text = "work additional"
    B10 > 56, then text = "do not work additional"

    This is just dummy text, but it represents what I am trying to accomplish. Can this be done using VBA?

    Also, I need to do it for 6 different text boxes.

    Thank you!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Replacing specific text in multiple text boxes based on cell values

    May be something like this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  2. [SOLVED] Replacing specific text in multiple cells
    By nobodyNZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2014, 11:19 AM
  3. Replacing specific text in a cell by row and replace with text in another row
    By merQrey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 10:05 AM
  4. Replies: 1
    Last Post: 02-19-2014, 10:04 PM
  5. [SOLVED] How to auto populate multiple Text Boxes from list based on value of a cell
    By MooseAUH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 03:40 AM
  6. Pop-up text boxes based on cell values then disappeared after preset time
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2013, 07:19 AM
  7. Replies: 2
    Last Post: 02-19-2010, 03:55 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