+ Reply to Thread
Results 1 to 1 of 1

Adding additional inputs on userform vba

  1. #1
    Registered User
    Join Date
    08-18-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    18

    Question Adding additional inputs on userform vba

    Hi everyone,

    I have been trying to create or find the codes for creating additional inputs on userform, but I am unable to grasp the coding concept.

    Kindly refer to the attached sample order form.xlsm.

    In the userform:
    • Textbox1: Order Number
    • Textbox2: Number of Items - adjustable figures by Spinbutton1
    • Frame1:An area for Item IDs
    • Textbox3~xx: Item IDs (Textbox count based on value from Textbox2)
    • Commandbutton1: Submit Button
    • Commandbutton2: Cancel Button

    My intentions are to create the additional inputs based on the number of items ordered and storable at Data table on Submit Button Click.

    Thanking you in advance for helping me.

    Regards,
    Last edited by ashburnadam; 07-24-2015 at 05:56 PM.

+ 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] Userform Cancel button when clicked still inputs data
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2014, 01:04 PM
  2. Creating a userform? That would have 3 buttons and inputs would control the macro?
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2014, 12:41 PM
  3. [SOLVED] Storing userform textbox inputs as currency in an array
    By CaptainK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2014, 10:13 AM
  4. Replies: 3
    Last Post: 06-23-2013, 12:13 AM
  5. Replies: 4
    Last Post: 04-22-2012, 07:55 AM
  6. Replies: 4
    Last Post: 02-02-2011, 11:51 AM
  7. Help selecting a range in vba from userform inputs
    By grievesy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2006, 05:35 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