+ Reply to Thread
Results 1 to 5 of 5

UserForm Questions

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    10

    UserForm Questions

    Hi,


    Firstly, I need to create a Box in a UserForm which will allow me (by clicking on it) to select any Cell, in any sheet.

    Then, by clicking on a command button, I have to transfer Text from my TextBox to this Cell and clear the TextBox (and reset the counter - see below).


    Also, I need to create a counter (will explain more in a sec) for the number of operations I have done using my UserForm.

    Let's say I press my Calculate button once, it will write some text in my TextBox with the number 1- infront. If I do it another time, it will write 2- (and text).

    So it should look like this :

    1 - "Random Text"
    2- "..........."
    3- "Etc..."


    If you need more information (as this may not be very clear) please let me know.

  2. #2
    Registered User
    Join Date
    11-23-2012
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: UserForm Questions

    I just noticed I should have explained the 2nd macro in first and vice versa. It's easier to understand and it should be done in that order anyways.

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

    Re: UserForm Questions

    It's not 100% clear what you want to do but for the first part, selecting a cell on any worksheet, take a look at the RefEdit control.

    The no of operations and counter things that are the things I can't quite understand.

    What sort of 'operations' do you mean?

    What's the purpose of the counter?

    Perhaps an overview of what you are trying to achieve might help.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    11-23-2012
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: UserForm Questions

    .nevermind
    Last edited by Sam9530130; 11-25-2012 at 02:44 AM.

  5. #5
    Registered User
    Join Date
    11-23-2012
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: UserForm Questions

    Posted twice by accident.
    Last edited by Sam9530130; 11-24-2012 at 09:38 PM. Reason: It posted twice, sorry

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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