+ Reply to Thread
Results 1 to 2 of 2

convert shape to number

  1. #1
    Registered User
    Join Date
    06-09-2017
    Location
    germany
    MS-Off Ver
    2010
    Posts
    23

    convert shape to number

    Dears,

    i am looking for a vba code that will allow me to replace a shape into a number or a letter in a cell attached is the sheet i was working on i had a code that works for 1 cell but i couldnt make it run on the whole sheet replacing all the shapes

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,174

    Re: convert shape to number

    You may get more help if you post an example workbook of what you already have. We can then fully understand what shape to number means.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Cheers
    Andy
    www.andypope.info

+ 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] Help with finding column number using month and shape number
    By dad812 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2019, 08:46 PM
  2. How to Formulate a way to Draw a Shape by Number Input?
    By Rick-O-Shay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-07-2016, 01:50 PM
  3. Replies: 1
    Last Post: 12-15-2014, 08:46 PM
  4. [SOLVED] How to Determine Index Number of New Shape
    By Malibumus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2012, 12:33 PM
  5. [SOLVED] how to change the shape number of an image
    By yeshwant_sur in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 10-10-2012, 07:48 AM
  6. Selected shape index number
    By Weston33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2012, 08:00 AM
  7. Shape's Index number?
    By Dr.Ile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2007, 07:29 AM

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