+ Reply to Thread
Results 1 to 2 of 2

How to perform enter key operation through User Form

  1. #1
    Registered User
    Join Date
    05-28-2018
    Location
    Pakistan
    MS-Off Ver
    Office 365
    Posts
    7

    How to perform enter key operation through User Form

    Hi
    Everyone I have been stuck in a problem could you please help.

    Actually the problem is:

    I have two columns one with names of cities and the other one is their pictures.

    using this Formula:

    =INDIRECT(ADDRESS(2-1+MATCH(Sheet4!$G$2, Sheet4!$A$2:$A$5, 0), 2))

    I am able to filter the record, like if I enter Pakistan the next cell shows its picture.

    Now, What I am trying to do is, I want to enter the value throgu a user form text box, So if I enter Pakistan then it will chnage its picture to Pakistan.


    Where I am right now?

    I have designed the form, also I am able to send the value from text box to cell (Names) where the fomrula is implemented, but doing so did not chane the picuture, whereas I enter a value manually in that cell and press enter, it works absolutely fine.

    Why I want to do this because, I want the record to be dynamic I mean whatever the user will enter in the text box the picutre should be changes in to the next cell.

    Looking forward for you help.
    Thanks
    Shozib
    Attached Images Attached Images

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: How to perform enter key operation through User Form

    An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

    The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] User Form to enter mileage
    By bjohnsonac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2017, 02:04 PM
  2. [SOLVED] User Form with Empty row but user may enter data manually
    By Nole68 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2015, 11:35 AM
  3. User Form To enter Time
    By dollar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2009, 03:19 AM
  4. Not have Permission to perform operation
    By L_ter in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-09-2009, 05:07 AM
  5. How To Enter A Value To A Cell With A User Form??
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2008, 11:20 AM
  6. User Form to Enter Information
    By Wskip49 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2008, 02:30 PM
  7. Need to disable Enter key in User Form
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2007, 12:14 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