+ Reply to Thread
Results 1 to 3 of 3

Activate Cell after i click the value in Application.InputBox

  1. #1
    Registered User
    Join Date
    10-25-2016
    Location
    mumbai
    MS-Off Ver
    2010
    Posts
    47

    Activate Cell after i click the value in Application.InputBox

    Hello Guys,

    When i use the Application.inputbox(), i select a value on the excel sheet to get it stored in some variable. I want the selected cell to be the Activecell cell now. Is there a way to do it?

    Thanks in Advance

    Unbenannt1.jpg

  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: Activate Cell after i click the value in Application.InputBox

    That method is meant for the activesheet. Were you wanting to allow selecting some range on some other sheet as well?

    If you post your code, it might be easier to see what might go amiss.

    I would use Select but feel free to change to suit.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-25-2016
    Location
    mumbai
    MS-Off Ver
    2010
    Posts
    47

    Re: Activate Cell after i click the value in Application.InputBox

    Perfect! Thanks a lott!

+ 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] Activate Workbook using InputBox
    By VitoBdG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 09:15 AM
  2. [SOLVED] Inputbox vs. Application.InputBox
    By miyachow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2013, 12:53 PM
  3. Double click cell to activate outlook
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2013, 07:53 AM
  4. Click on a cell and have that worksheet with the same name activate
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-30-2012, 03:17 PM
  5. 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
  6. Inputbox and activate sheet
    By Luth6322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2010, 01:44 AM
  7. activate cancel button in a inputbox
    By mania112 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2009, 07:09 AM
  8. Click cell to activate macro
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-27-2006, 12:25 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