+ Reply to Thread
Results 1 to 8 of 8

Userforms - display as a percentage from a Combobox

  1. #1
    Registered User
    Join Date
    04-23-2010
    Location
    Berkshire
    MS-Off Ver
    Excel 2003
    Posts
    4

    Cool Userforms - display as a percentage from a Combobox

    Hi

    Need some help - I have a UserForm which requires selection from a ComboBox - the SourceRow displays in the worksheet is in percentage form but when you click on and make a selection it reverts to the numberical value 0.045 rather than the percentage.

    How do I fix this? To display the same when it is selected?

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Userforms - display as a percentage from a Combobox

    You can try with this code:
    Please Login or Register  to view this content.
    Regards,
    Antonio

  3. #3
    Registered User
    Join Date
    04-23-2010
    Location
    Berkshire
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Userforms - display as a percentage from a Combobox

    Hi Antonio - my userform has Textboxes as well as Combobox's - these have text values so would the myValue be say Current.Value .... (Current being the Combobox name?)

  4. #4
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Userforms - display as a percentage from a Combobox

    You may use this code:
    Please Login or Register  to view this content.
    Regards,
    Antonio

  5. #5
    Registered User
    Join Date
    04-23-2010
    Location
    Berkshire
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Userforms - display as a percentage from a Combobox

    Brilliant - works great!!

  6. #6
    Registered User
    Join Date
    01-13-2009
    Location
    Nitra, Slovakia
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Re: Userforms - display as a percentage from a Combobox

    I can't get this work though I have the same problem as mentioned in the first post...When I put:
    Please Login or Register  to view this content.
    I get an error 380. Could not set the text property. Inavalid property value.

  7. #7
    Forum Contributor
    Join Date
    09-14-2012
    Location
    Tucson, Arizona, USA
    MS-Off Ver
    Office 2010
    Posts
    105

    Re: Userforms - display as a percentage from a Combobox

    Dexter666, change your value from "#0,00%" to "#0.00%" and see if that works for you

  8. #8
    Registered User
    Join Date
    01-13-2009
    Location
    Nitra, Slovakia
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Re: Userforms - display as a percentage from a Combobox

    No, it did't help. Same error message as before...

+ 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