Results 1 to 10 of 10

autonumbering based on two textboxes together on userform for two sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-21-2022
    Location
    africa
    MS-Off Ver
    2019
    Posts
    146

    autonumbering based on two textboxes together on userform for two sheets

    Hi
    I have two textbox1,2 and optionbuttons1,2 if I select optionbutton pay then should match with sheet name to autonumbering for column B and copy to sheet PAY and the same thing about sheet SEL when run the useform from first time and fill in textbox 2 (AMOUNT) for instance will brings the first word from optionbutton1(PAY) and brings the amount from textbox2 and write the current month and current year and brings the last name from optionbutton name PAY & 001 if I press commandbutton then should copy to sheet PAY and when run again will inceremnt number based on last autonumbering in column B and increase the number for the last item , the same thing should happens for sheet sel but if I run the userform and autonumbering whether from first time or incerement and not press commandbutton then should not autonumbering and not copy to sheet then should cancel process.
    I post some pictures to understanding closely
    from first sheet pay
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add Textboxes to UserForm from Inputbox Range Selection and Use Textboxes to Create Table
    By RoroBear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2021, 10:07 AM
  2. [SOLVED] Populate UserForm textboxes based on ComboBox value
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2020, 05:57 PM
  3. Want Average on userform textboxes to ignore blank textboxes
    By cvanderweide92177 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-10-2018, 12:47 PM
  4. populate textboxes in userform based on cells values
    By Yokosuka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2016, 01:50 PM
  5. [SOLVED] UserForm to complete TextBoxes based on ComboBox
    By WimpieOosthuizen in forum Excel General
    Replies: 9
    Last Post: 05-31-2014, 03:43 AM
  6. Textboxes within Userform to display info based on combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2012, 12:40 PM
  7. autonumbering in a userform
    By Mark Campbell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2011, 11:14 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