+ Reply to Thread
Results 1 to 2 of 2

Class Module to design a class based on an autoshape (arrow)

  1. #1
    Registered User
    Join Date
    07-20-2017
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    1

    Class Module to design a class based on an autoshape (arrow)

    Hi Everyone,
    This is my first post here - recently started in excel vba (I originally started in vb.net as a hobbyist)

    Question..... can I make a class module from autoshapes

    I can create the class ok, and I can create the variables needed, but then I come to a stop - the intellisense doesn't help me anymore and after several weeks off on/off researching I cannot find any help. There are many places I've found that give help on creating a class but they all use strings, integers etc to make the variables, and I need to use autoshapes.
    Or, is it possible to create my own shape...???
    Or, could I design something in vb.net and import that into my Excel workbook??

    Any tips or pointers would be greatly appreciated, thanks
    Have a great day!!!
    Steve

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Class Module to design a class based on an autoshape (arrow)

    Hi,

    I'm afraid your question doesn't make any sense- to me at least. What exactly do you mean by "make a class module from autoshapes"? You can certainly have class properties that set or get autoshape objects.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Place code in userform, module or class module
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2017, 07:04 AM
  2. “= 1st class’ lower class limit + class width"
    By CheeseFace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2016, 08:21 PM
  3. [SOLVED] Getting value from a class module
    By TankBuilder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2013, 05:33 PM
  4. [SOLVED] ComboBox class .AddItem filled in class module
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-03-2012, 05:48 AM
  5. Replies: 1
    Last Post: 08-30-2011, 02:23 AM
  6. using class module
    By tom taol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2006, 12:15 PM
  7. Class module
    By Avner Mediouni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2005, 11:06 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