+ Reply to Thread
Results 1 to 2 of 2

How do i work with groupsof shapes and textboxes with vlookup?

  1. #1
    Registered User
    Join Date
    03-05-2024
    Location
    Ohio Usa
    MS-Off Ver
    2401
    Posts
    1

    How do i work with groupsof shapes and textboxes with vlookup?

    I have four shapes drawn in an Excel sheet using the 'Insert Shape' feature. Each shape has different dimensions, represented by their length and width. I have a column for the shape name, length, and width for all shapes. My goal is to display only one shape at a time on the sheet based on the selected shape name (e.g., Shape 1, Shape 2, Shape 3). After displaying the selected shape, I want to show its length and width in text boxes used to label the lengths and widths on the shapes. Furthermore, I want the lengths and widths of these shapes to update in the text boxes when I input different values in the corresponding columns for each shape name. Can you provide a solution for achieving this in Excel?

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How do i work with groupsof shapes and textboxes with vlookup?

    In the file attached there are some exemples of what you can do with shapes.
    For more control try the macro/VBA topic.
    Attached Files Attached Files

+ 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] Code in userform to be flexible and work with multiple textboxes
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-21-2015, 11:04 AM
  2. [SOLVED] Greater than doesn't work when comparing values from two textboxes
    By torppo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2014, 06:04 AM
  3. SetFocus doesn't work properly on a Userform on ComboBoxes and TextBoxes
    By pimre in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-15-2013, 03:15 PM
  4. [SOLVED] Adding Hyperlink to Shapes - Why wont this work ???
    By Alina1404 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2012, 03:18 AM
  5. How to select a group of shapes and textboxes with a vba macro in excel Mac 2011?
    By eratosthene in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-03-2012, 10:19 PM
  6. Vlookup between two textboxes
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2012, 03:23 PM
  7. [SOLVED] ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False
    By Joe HM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2006, 02:50 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