+ Reply to Thread
Results 1 to 7 of 7

Updating text in shape using data entered in a textbox in userform.

  1. #1
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Lightbulb Updating text in shape using data entered in a textbox in userform.

    HII!!
    I have a shape and it has this text in the shape:-

    ID: 1648280
    Title: NR Analysis and report for colon 2016_12
    Completed work: 7
    Remaining work: 3

    Now i Have a userform which appears after selecting the shape. and it has one text box with label completed work and one button - Save.

    Now when i enter the value in the textbox and save it the shape should update to following text:-

    ID: 1648280
    Title: NR Analysis and report for colon 2016_12
    Completed work: '​value user enters in UserForm1 textbox'
    Remaining work: 0

    How do i do it?

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Updating text in shape using data entered in a textbox in userform.

    Something like this.

    Please Login or Register  to view this content.
    You could also rwcord a macro and just select that shape and edit the text.
    Then you can look at the generated code and change it to your requirements
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: Updating text in shape using data entered in a textbox in userform.

    I am using excel 2007 version. i have tried recording macros for shapes. but it doesn't capture any action taken on shapes or within shapes.

    Plus, i want most of the text in shape to stay as it is. I just want the value of completed work and remaining work to get updated.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Updating text in shape using data entered in a textbox in userform.

    Sorry, can't help. Works with me so you must be doing something else.
    I would like to look at the file, so if you can attach it, okay with me.
    Or else you will just have to figure out how to select that shape and edit the text you want

  5. #5
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: Updating text in shape using data entered in a textbox in userform.

    Here is the attached file...
    you need to move the shape from inwork lane to completed lane inorder to appear userform.

    I just need upper two lines (id and title) also to appear in the shape after hitting save button...
    rest of the things are managed.
    Attached Files Attached Files
    Last edited by Awni; 06-23-2016 at 05:46 AM.

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Updating text in shape using data entered in a textbox in userform.

    This would be the main idea
    Select the left top rectangle (IT IS NOT A TEXTBOX) and open the userform, enter a value and press save
    I just changed the Completed Work: but you could then edit any part of this. It is read as an array

    You could try this:
    Please Login or Register  to view this content.
    The only thing you need to pass to the userform is the rectangle's name, You've got Rectangle 10, 4, 5 and 6 here.

  7. #7
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: Updating text in shape using data entered in a textbox in userform.

    Wow!! Thanks
    That works!! Split And Replace function... New things i learnt today

+ 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. Updating text in shape and the sheet after saving data through Userform1.
    By Awni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2016, 02:40 AM
  2. [SOLVED] Can I Enter the text appears in shape I select into the userform textbox/ listbox/ label?
    By Awni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2016, 07:57 AM
  3. Restrict the value entered into a textbox on a userform
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2015, 05:30 PM
  4. Hide Shape based on text entered in another worksheet
    By mrbickelsworth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 02:15 AM
  5. [SOLVED] Validate Userform Text Box against data already entered
    By dieseldogpi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 11:40 AM
  6. Userform Textbox updating a another userform textbox (im stuck!!)
    By wapwap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-31-2011, 02:56 PM
  7. Updating Textbox in UserForm
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2009, 01:55 PM

Tags for this Thread

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