+ Reply to Thread
Results 1 to 3 of 3

Can I Enter the text appears in shape I select into the userform textbox/ listbox/ label?

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

    Can I Enter the text appears in shape I select into the userform textbox/ listbox/ label?

    Hii!!!
    I have number of shapes on my sheet and different text entered into each shape.
    Now when i select a particular shape, userform1 appears.
    I want that somehow the same text which is in the shape i selected should appear in the userform1 that appears after selecting the same shape.
    And user should not be able to change that data which appears in userform1.
    Please help me out. Thanks in advance!!

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Can I Enter the text appears in shape I select into the userform textbox/ listbox/ lab

    Hello
    Assign the Macro to your shapes:

    Please Login or Register  to view this content.
    This shows Userform1 with a Label showing the Shape text.

    DBY

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

    Re: Can I Enter the text appears in shape I select into the userform textbox/ listbox/ lab

    Thanks... That works!!!

+ 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. Filter Listbox using textbox, Select one result and assign values to label
    By raiken20 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-27-2016, 08:11 PM
  2. VBA - Userform - Listbox validation and Listbox to Textbox
    By stevefisher85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2016, 07:11 AM
  3. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  4. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  5. [SOLVED] Userform to show date format in textbox or label
    By coach.32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2013, 08:55 PM
  6. userform: trasnferring textbox value to label field in next userform
    By brillison in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2008, 08:18 PM
  7. Userform Textbox and Label change from cell
    By Panic in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-20-2008, 08:36 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