+ Reply to Thread
Results 1 to 3 of 3

ReWork of and Old question

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    30

    ReWork of and Old question

    Hello:
    I am looking for a way to up date the format in a textbox based on if the value of an option button is true.
    For the most part i have it figured out using the "OptionButto.._Click()". or the "........_Change()" within the text box itself.
    So far what i have looks like this:
    Please Login or Register  to view this content.
    As you can see I'm wanting the textbox to change based on which optionbutton is chosen to reflect the desired format for that option. This works? if all I click is one optionbutton. What i need it to do is work backwards, so no matter which option you choose the textbox will reflect the desired format. And if it helps or makes a difference in what I need to do, both optionbuttons are in a Frame.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,656

    Re: ReWork of and Old question

    So I assume your textbox is called Number
    so in Number_Change event handler
    or may be even better in Number_Exit
    check current state of optionbuttons and format textbox appropriate way

    Please Login or Register  to view this content.
    PS. the thread title could be a bit more descriptive :-P try to rework it or at least use better one next time (shall be like minisummary: "formatting textbox value determined by optionbuttons" or something similar )
    Best Regards,

    Kaper

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: ReWork of and Old question

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Rework _KeyPress code into a sub routine or class that can be called by multiple events
    By jonharrell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2015, 02:31 AM
  2. [SOLVED] Merge cells with same value, old code needs rework.
    By johansoder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 09:14 AM
  3. [SOLVED] Rework in vba code to refresh sum value.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2013, 02:54 AM
  4. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  5. [SOLVED] Compound If()Countif() formula that needs rework. *first post*
    By Leif Magnus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2012, 10:48 PM
  6. how do i rework the sequence of data
    By ranjan in forum Excel General
    Replies: 3
    Last Post: 05-08-2007, 09:11 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