+ Reply to Thread
Results 1 to 7 of 7

Application.InputBox from Userform

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    Application.InputBox from Userform

    I have a userform that pops up, and from that userform, I would like to click a button that pops up an inputbox (application.inputbox) where I can select cells on the sheet, and then run more code. When the application.inputbox appears, I'm not able to click on any cell because I think the original userform is blocking me from doing so. I've tried changing this userform to modal and modeless, but I'm not having any luck. Can someone please help?

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Application.InputBox from Userform

    Hi,

    Please share your code or file to see what have you done?

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Application.InputBox from Userform

    I managed to do that with RefEdit
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-31-2014
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Application.InputBox from Userform

    As I started playing around with this more, I stuck with my application.inputbox solution, and found that by turning screen updating back to True, it now works! I had is set at false at the beginning of the code. I had no idea this would prevent this from working! Thank you both for the quick replies.

  5. #5
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Application.InputBox from Userform

    Hi,

    If you are satisfied with someone's answer, please mark this thread as SOLVED. And click on * to add reputation as way to say thanks.

    Regards,
    Paresh

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Application.InputBox from Userform

    Couldn't you use a RefEdit control instead of Application.InputBox?
    If posting code please use code tags, see here.

  7. #7
    Registered User
    Join Date
    07-31-2014
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Application.InputBox from Userform

    In this case, the input box suited my needs better. I hadn't heard of RefEdit before...that could come in handy!

+ 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] Inputbox vs. Application.InputBox
    By miyachow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2013, 12:53 PM
  2. [SOLVED] Using Application.InputBox gives Errors
    By boela in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 10:44 AM
  3. [SOLVED] Application.Inputbox
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2012, 09:16 AM
  4. Screen positioning inputbox that is set as Application.InputBox
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2010, 07:59 AM
  5. Application.inputbox
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2009, 11:27 AM

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