combobox fraction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spencer.Sadkin@gmail.com - 12 Mar 2008 20:44 GMT

I have a combobox populated with fractions that display properly.
After selection the fraction converts to a decimal, but the list
values are still fractions. How can i display the selected value as a
fraction?

Thanks

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Mar 2008 22:04 GMT

Can you show/tell us how you populated the ComboBox with your fractions?

Rick

>I have a combobox populated with fractions that display properly.
> After selection the fraction converts to a decimal, but the list
> values are still fractions. How can i display the selected value as a
> fraction?
>
> Thanks

Reply to this Message

Spencer.Sadkin@gmail.com - 13 Mar 2008 17:36 GMT

On Mar 12, 5:04 pm, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:

> Can you show/tell us how you populated the ComboBox with your fractions?
>
[quoted text clipped - 10 lines]
>
> > Thanks

ya that was it, i figured it out yesterday. the populated values from
the cells were entered as 0 1/3 which shows in the formula bar as .
33333333 so it was already converted before being passed to the
routine... i fixed this by entering them as '1/3 and then converting
to a number in the routine

Thanks again

Reply to this Message