+ Reply to Thread
Results 1 to 7 of 7

UserForm: i want to create a adjustable (Resizer) userform

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Post UserForm: i want to create a adjustable (Resizer) userform

    Hello Evryone
    how r u, hope u will be fine

    i want to make my UserForm Adjustable ( Resizer )............i m posting here a sample of Adjustable ( Resizer) UserForm, and also pasting my own UserForm plz

    make my Userform Adjustable ( Resizer )

    thanx a lot

    my user form
    My own UserForm.xlsm

    example of Resizer Form

    Resizer Form.xls

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: UserForm: i want to create a adjustable (Resizer) userform

    Did you even try?

    Add the class object to your project.
    The add the first set of code to your userform to define, initialize and display the resizer object.

    Of course from there you would need code to adjust the controls size and position.
    http://www.andypope.info/vba/Anchor.htm

    Or playwith the userforms Zoom setting
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: UserForm: i want to create a adjustable (Resizer) userform

    hello Andy Pope

    i have a little knowledge of vba

    will u add ur code in my form?

    best regards
    haroon2015

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: UserForm: i want to create a adjustable (Resizer) userform

    No I will not. This is a "help" forum and not a "do it for you" one.

    If you don't understand VBA well and don't intend to try yourself why don't you simply make the userform you already have bigger by reszing the control in design mode.

  5. #5
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: UserForm: i want to create a adjustable (Resizer) userform

    @andy

    Good question, for someone who claims "little knowledge of VBA" the OP has asked about 35 questions on this forum alone in the current Month...

    Curious????

    Jmac

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: UserForm: i want to create a adjustable (Resizer) userform

    OK
    Andy Pope

    thanx for ur help
    Last edited by HaroonSid; 03-22-2014 at 08:23 AM.

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: UserForm: i want to create a adjustable (Resizer) userform

    hello Andy Pope


    Thanx alot for to give me power to do this

    i have done this and leaned something new

    best regards
    haroon 2015

+ 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. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  3. [SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values
    By dragonabsurdum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2013, 01:38 PM
  4. [SOLVED] Open a userform from a userform, but preserve the info in the original userform
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 02:38 PM
  5. userform is large.....how to use scrollbar of userform to show all of the userform
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 04:11 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