+ Reply to Thread
Results 1 to 5 of 5

VBA For Set Value To Range Of Cells By Forms And Buttons

  1. #1
    Forum Contributor kar2rost's Avatar
    Join Date
    07-02-2022
    Location
    Here
    MS-Off Ver
    Pro Plus 2021 (Windows 11 21H2 64-bit)
    Posts
    121

    VBA For Set Value To Range Of Cells By Forms And Buttons

    Hello to all

    I want to enter multi numbers manually by textbox in form1 in column A.I solved the first one myself

    my problem is : show form2 and after click insert data to set value in column B as range input number .after show form2 and after click insert data to set value in column C as range input number . the corresponding with the entered numbers

    if run file You will understand what I mean

    How can I do this?
    tank u
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by kar2rost; 10-31-2023 at 09:55 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,952

    Re: Giving value to cells in groups by Nested form

    How does this differ from your current thread: https://www.excelforum.com/excel-pro...n-columns.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor kar2rost's Avatar
    Join Date
    07-02-2022
    Location
    Here
    MS-Off Ver
    Pro Plus 2021 (Windows 11 21H2 64-bit)
    Posts
    121

    Re: Giving value to cells in groups by Nested form

    Quote Originally Posted by AliGW View Post
    How does this differ from your current thread: https://www.excelforum.com/excel-pro...n-columns.html
    Hi Good day
    The difference is that in the post you mentioned, the cells in column B and C are filled one by one
    But here I want it to be filled in groups
    Here I am also looking for a solution to batch input the column A numbers
    With the form or any way that friends know
    Thank you for your attention

  4. #4
    Forum Contributor kar2rost's Avatar
    Join Date
    07-02-2022
    Location
    Here
    MS-Off Ver
    Pro Plus 2021 (Windows 11 21H2 64-bit)
    Posts
    121

    Re: VBA For Set Value To Range Of Cells By Forms And Buttons

    hi all
    Can someone solve this problem?
    tanks a lot

    @JeteMc
    @bebo021999
    @Logit
    @6StringJazzer
    plzzzzzzzz
    Last edited by kar2rost; 10-31-2023 at 11:44 AM.

  5. #5
    Forum Contributor kar2rost's Avatar
    Join Date
    07-02-2022
    Location
    Here
    MS-Off Ver
    Pro Plus 2021 (Windows 11 21H2 64-bit)
    Posts
    121

    Re: VBA For Set Value To Range Of Cells By Forms And Buttons

    Quote Originally Posted by kar2rost View Post
    hi all
    Can someone solve this problem?
    tanks a lot

    @JeteMc
    @bebo021999
    @Logit
    @6StringJazzer
    plzzzzzzzz
    You have helped a lot here
    Please help me too, thank you very much
    @JeteMc
    @bebo021999
    @Logit
    @6StringJazzer
    @torachan

+ 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] Nested Loop does not transfer value of each cell in Range to another worksheet!
    By realbestpete in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2019, 02:06 AM
  2. [SOLVED] Modify the first nonempty cell (Using INDEX?) in a range based on nested IF statements
    By excel_novice2019 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2019, 02:28 PM
  3. Nested If formula that chooses first cell in a range with data
    By mikkicromer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2013, 01:47 AM
  4. [SOLVED] IF statement (non nested) that compares cell value against range
    By r2d3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2006, 08:11 AM
  5. IF statement (non nested) that compares cell value against range
    By r2d3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2006, 06:10 PM
  6. how to select cell range with form?
    By jagexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2006, 05:30 PM
  7. [SOLVED] Nested IF statement with cell range reference
    By Joe Spicer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-15-2005, 04: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