+ Reply to Thread
Results 1 to 3 of 3

option button on userform to enter value from textbox into the worksheet

  1. #1
    Registered User
    Join Date
    04-08-2019
    Location
    Zambia
    MS-Off Ver
    2016
    Posts
    2

    option button on userform to enter value from textbox into the worksheet

    Greetings,

    Please, I urgently need your help with the code for the option/radio button on userform to enter value from textbox into the worksheet.

    I am working on an a fund accounting worksheet. I want to be able enter an amount in a textbox and then make a selection on the option button, the amount should be recorded in specific column under 4 headings. I have 4 funds, so for example I record 2000$ in the textbox and select F1 on the option button, the 2000$ should be recorded under F1.

    Thank you
    Last edited by Mbisa; 04-08-2019 at 06:25 AM.

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: option button on userform to enter value from textbox into the worksheet

    Something like this?
    See attached.
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-08-2019
    Location
    Zambia
    MS-Off Ver
    2016
    Posts
    2

    Re: option button on userform to enter value from textbox into the worksheet

    Yes please I really appreciate. I have applied on my file it is working but it is replace the old data, its not offsetting.
    am failing to upload directly on the forum...Please can you give me your email, so that I send the file to you. I am new and not allowed to upload anything or add links.

    I really need your advise.

    Thank you so much

+ 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. Replies: 6
    Last Post: 07-15-2017, 09:54 AM
  2. [SOLVED] Textbox and Option Buttons - If Textbox has a Value then an Option Button must be selected
    By MeerkatMatt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2014, 07:45 AM
  3. [SOLVED] Help With Using Option Button and Textbox with A Command Button
    By VBTroubles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2014, 09:40 AM
  4. [SOLVED] Enter the name of the worksheet (tab) in Textbox and after pressing the button to go to Sh
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2012, 10:15 PM
  5. Replies: 3
    Last Post: 05-07-2012, 09:46 PM
  6. Userform option button starts a loop that searches worksheet and populates listbox
    By silvertyphoon1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2010, 01:58 AM
  7. Userform Option Button to Show/Hide Another Option Button on same Userform
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2010, 09:44 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