+ Reply to Thread
Results 1 to 4 of 4

Msg box based on cell value from user form entry

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Msg box based on cell value from user form entry

    Hello, I am new to User Forms. I created a user form and it populates the data base fine. Based on the data entry from the user form there is a formula in column J that creates a unique number in that row of the data base. I would like a message box to appear with the unique number.

    Ex: first entry using the user form populates columns A thru I on row 2. I want a message box with the value in J2.

    Any help would be appreciated.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Msg box based on cell value from user form entry

    Perhaps
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    08-08-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Msg box based on cell value from user form entry

    thank you for the response. But with each entry from the user form, the row would change. So it would not always be J2.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Msg box based on cell value from user form entry

    You haven't posted any code, but you would use the same method to determine which cell to get the data from as you would to determine which cell to put the data in.

+ 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. Insert Rows Based on text Box Entry in User Form
    By aqhibjaveed2183 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 02:44 AM
  2. Fill Value in a Cell Based on User Entry
    By NaNaBoo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2009, 12:09 PM
  3. Message box based on user entry in cell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2008, 04:41 PM
  4. Filter Excel Pivot, based on user entry form
    By Jayco in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 01:10 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