+ Reply to Thread
Results 1 to 2 of 2

User form calc, passing variables,cmb box issue

  1. #1
    Registered User
    Join Date
    11-08-2016
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Question User form calc, passing variables,cmb box issue

    -Have user form with sceenshot included here. I need the cmb to look better. i only have 4 values in list. do i just use properties and resize etc..or is there a way to always show top value in list?
    - I need the focus to move to next text box(volume bbls)- BUT users can choose the same tank so the value of txttank may not change. How do i ensure no matter what value they choose, the tab will move to volume after entry of tank #.
    - i need a simple calculation on exit of txtMON. do i use EVENT, like key up or down, or soemthignto that effect. I dont want to use the cmd button i have temporarily placed. its simple addition and then dividison so its unneeded. simplest way upon exit MON value, for the next field (txtrm) to autofill with answer.
    -i have reviewed syntax help on excel vba, but i really need to know a few things..like meaning of what options i have avaialbe...when i use the syntax help, eg. VALUE...i dont see real life examples..i guess i need a good code basic manual with the 'notes" or "code explained" in green in an example...they tend to have one line or many lines, and i need to know what like does what? does anyone have a suggested site or reference location? my brain gets tired of fighting with this..

    Thanks ahead of time for any help you can give.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: User form calc, passing variables,cmb box issue

    How do i ensure no matter what value they choose, the tab will move to volume after entry of tank #.
    Set the TabIndex in the fields properties to be the next number from TANK ie of TANKs tabindex = 4 make VOLUME = 5 etc
    If someone has helped you then please add to their Reputation

+ 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. help passing textbox value from user form to variable
    By mike760534211 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2015, 03:25 PM
  2. Passing values to a second user form.
    By Coleman34 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2014, 11:24 AM
  3. Passing Values from User Form
    By srinivassurapareddi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2012, 01:49 PM
  4. Passing inputs from one user form to another
    By daymaker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2011, 11:02 AM
  5. Passing variables from sub to user form
    By boc_est1986 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2009, 09:09 AM
  6. [SOLVED] User Form value passing problem
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2006, 12:24 PM
  7. Passing variables between a form and macro
    By David in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-05-2005, 12:05 AM

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