Results 1 to 2 of 2

User form calc, passing variables,cmb box issue

Threaded View

  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

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 brusk2@uiuc.edu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2006, 12:24 PM
  7. [SOLVED] 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