+ Reply to Thread
Results 1 to 13 of 13

Userfrom to Start Show in a Particular Cell

  1. #1
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Userfrom to Start Show in a Particular Cell

    Dear Experts,

    Would need your suggestion on my subjected Query!

    I have created a Userfrom named as “CC_DE_Form”

    When this from Initialize, By default I want this to be startup in “MM_Input” worksheet; Cell I2 Position (Top, Left).

    Could you please help me with coding which meets above request?

    Thanks & Regards,
    Rajeshkumar R
    Last edited by Rajeshkumar R; 10-23-2017 at 04:08 AM. Reason: Query Resolved

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Userfrom to Start Show in a Particular Cell

    You want the userform to be launched when cliking or changing cell I2 in sheet “MM_Input” or you want the cell I2 to be selected when the form has been launched ??
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Re: Userfrom to Start Show in a Particular Cell

    Dear PCI ,

    Thanks for your instant response! I have a button call "Open Form" in my worksheet; When User click on that button "CC_DE_Form" Userfrom to be Displayed keeping I2 cell as Top, Left Reference.

    Thanks & Regards,
    Rajeshkumar R

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Userfrom to Start Show in a Particular Cell

    Clear, to do that you have to put in the code to show the userform at the end
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Re: Userfrom to Start Show in a Particular Cell

    Dear PCI ,

    I used below code, but my user form did not started keeping I2 Cell as Top, Left Reference.

    Please Login or Register  to view this content.
    Thanks & Regards,
    Rajeshkumar R

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Userfrom to Start Show in a Particular Cell

    Put the code sent AT THE END
    Please Login or Register  to view this content.

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,679

    Re: Userfrom to Start Show in a Particular Cell

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  8. #8
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Re: Userfrom to Start Show in a Particular Cell

    Dear PCI & bakerman2 ,

    I am sorry to say this; Above both suggested codes are doesn't positioning my userform in I2 Cell as Top, Left Reference, When it opens!

    Thanks & Regards,
    Rajeshkumar R



  9. #9
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Userfrom to Start Show in a Particular Cell

    Does the sheet "MM_Input" the active one, the one shown ??
    Finally you want the Userform to be placed in sheet "MM_Input" and the left top corner of the form to be in I2 ...is it ?
    Last edited by PCI; 10-22-2017 at 08:21 AM.

  10. #10
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Re: Userfrom to Start Show in a Particular Cell

    Dear PCI,

    Does the sheet "MM_Input" the active one, the one shown ??

    Yes "MM_Input" Sheet is an Active Worksheet Only!

    Finally you want the Userform to be placed in sheet "MM_Input" and the left top corner of the form to be in I2 ...is it ?

    Yes Please!!!

    Thanks & Regards,
    Rajeshkumar R

  11. #11
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,679

    Re: Userfrom to Start Show in a Particular Cell

    You can do it the difficult way like http://www.cpearson.com/Excel/FormPosition.htm

    or you can use this and play around with the numbers until you get the correct position.

    Please Login or Register  to view this content.

  12. #12
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,529

    Re: Userfrom to Start Show in a Particular Cell

    Rajeshkumar,
    I was using the same code as the one proposed by bakerman2 but I got some concern when using different zoom ratio:
    Just For information
    PCI

  13. #13
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    321

    Re: Userfrom to Start Show in a Particular Cell

    Dear bakerman2 ,

    Thanks for your suggestions, it is working fine with my requirement!

    Dear PCI ,

    Noted, I didn't find any issue with my requirement, Hence; right now I go with this proposal!

    Thanks & Regards,
    Rajeshkumar R

+ 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. Start screen won't show up after my XLL loaded
    By neu_stone in forum Office 365
    Replies: 3
    Last Post: 09-18-2017, 05:37 PM
  2. [SOLVED] How to start count after 4 times the number show up
    By davi65 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 11-05-2016, 03:12 PM
  3. [SOLVED] UserFrom : Select Range And Show In Text Box : Solved by : Bernie Deitrick
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2014, 01:16 AM
  4. A way to show conflicting start/end date tasks
    By garricko in forum Excel General
    Replies: 2
    Last Post: 05-05-2010, 08:11 PM
  5. How to show start and end of data ranges?
    By wildeone2010 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2010, 08:46 PM
  6. How to start the userfrom when opening xls file?
    By pninja005 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2006, 05:25 AM
  7. [SOLVED] How do show value range that doesn't start at zero
    By hoffmanjm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-03-2005, 04: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