+ Reply to Thread
Results 1 to 3 of 3

Looking for help with input boxes

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    8

    Question Looking for help with input boxes

    Hi,
    I'm brand new to these forums so tell me kindly if I'm doing something wrong and I'll do whatever I can. Thanks.

    I have code which creates a graph using data and repeats this for each sheet.

    Please Login or Register  to view this content.
    What I'm really interested in is creating a basic user input box which will take the information given and write it into the above code. That is, I need a dialogue box in which the user can set the size, location, ranges etc. of the chart code.

    What I've found so far only takes user input and writes it into sheet cells, not the vbcode. Is this possible with macros? Where would I start?
    Thank you for anything at all~

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Looking for help with input boxes

    there is InputBox - quite basic and limited capabilities tool. If it is not enough, you can design and use UserForm.
    But let's start with the simple one - try to play with it and develop your own way:

    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Looking for help with input boxes

    Thank you for your reply.
    I found the inputbox a bit limiting because it could only accept one value at a time, while I was hoping for a panel of options. I'm looking at userforms now and they seem to do the trick, and I see how to use your code for them as well. I'm also following existing tutorials to figure them out, so I have no immediate questions.

    Thank you very much for putting me on the track~

+ 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. Additional input Boxes, based on answer to first input box
    By DrBball7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 05:38 AM
  2. Input boxes
    By luke_p in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2008, 09:12 AM
  3. Input boxes
    By gav_69 in forum Excel General
    Replies: 6
    Last Post: 09-05-2008, 07:12 AM
  4. Input Boxes
    By Danielle88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2008, 11:56 PM
  5. Replies: 1
    Last Post: 11-09-2005, 06:40 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