+ Reply to Thread
Results 1 to 2 of 2

USER form..need to use to pass a variable to a cell reference and back.

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

    Question USER form..need to use to pass a variable to a cell reference and back.

    Have an excel workbook that is owned by someone else..I cannot change the essential essence of the book, however the interface is VERY user unfriendly and displays terrible.
    I have created a form in workbook to enter data, however i am stuck bec I cant figure out the code to have the form take an input, place it in a cell reference within the workbook, and then pass another result back to the form(calculation result)...the formulas are so convoluted, I cant repeat them..i just need to get cell references, in and out of book..Can someone help?

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: USER form..need to use to pass a variable to a cell reference and back.

    Welcome to the forum!

    Please Login or Register  to view this content.

+ 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. Pass a variable to another subroutine and get back the result
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2013, 04:55 PM
  2. [SOLVED] pass variable for user form module to function
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2012, 10:10 PM
  3. Pass Value/text from User Form to Macro
    By tompa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2011, 07:00 PM
  4. Pass variable from module to userform and back
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2006, 11:50 AM
  5. Pass a variable back to the host script?
    By mb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2005, 03:05 PM
  6. [SOLVED] Pass Excel User License to Variable
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2005, 08:05 AM
  7. How to pass a variable from Form back to calling procedure
    By John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2005, 11:05 AM
  8. Pass variable from user form to macro
    By r wilcox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2005, 03:06 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