ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box - HELP (https://www.excelbanter.com/excel-discussion-misc-queries/37750-combo-box-help.html)

ynissel

Combo Box - HELP
 
I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef

Dave Peterson

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef


--

Dave Peterson

ynissel

Combo Box - HELP
 
I send this file to other users who dont necessarily have the same version
excell as I do - and this is causing an error message to appear. Can this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef


--

Dave Peterson


Dave Peterson

Combo Box - HELP
 
What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same version
excell as I do - and this is causing an error message to appear. Can this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef


--

Dave Peterson


--

Dave Peterson

ynissel

Combo Box - HELP
 
Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file and
since its an ADDIN in the analysis tool pack many users of my file get errors
! Is there a way around this without making them install the add-in ?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same version
excell as I do - and this is causing an error message to appear. Can this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson


Dave Peterson

Combo Box - HELP
 
If you want continue to use =mround(), then you'll have to have that analysis
toolpak installed.

ynissel wrote:

Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file and
since its an ADDIN in the analysis tool pack many users of my file get errors
! Is there a way around this without making them install the add-in ?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same version
excell as I do - and this is causing an error message to appear. Can this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Peo Sjoblom

Combo Box - HELP
 
Regarding MROUND, you can get the same result using built in functions
but we need to know how you want to round first

--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file and
since its an ADDIN in the analysis tool pack many users of my file get

errors
! Is there a way around this without making them install the add-in ?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same

version
excell as I do - and this is causing an error message to appear. Can

this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great.

But the cell
its linked to - which is also formatted as % to 3 decimal places

wont format
as a % - and thats a displayed cell so I need it to format

properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson




ynissel

Combo Box - HELP
 
I always need to round to the nearest 1/8th.
So my function is mround(a1,.125)
Is there a built in function that can do the same thing ?
Thanks,
Yosef

"Peo Sjoblom" wrote:

Regarding MROUND, you can get the same result using built in functions
but we need to know how you want to round first

--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file and
since its an ADDIN in the analysis tool pack many users of my file get

errors
! Is there a way around this without making them install the add-in ?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same

version
excell as I do - and this is causing an error message to appear. Can

this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great.

But the cell
its linked to - which is also formatted as % to 3 decimal places

wont format
as a % - and thats a displayed cell so I need it to format

properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson





Peo Sjoblom

Combo Box - HELP
 
Yes

=ROUND(A1/0.125,0)*0.125


--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
I always need to round to the nearest 1/8th.
So my function is mround(a1,.125)
Is there a built in function that can do the same thing ?
Thanks,
Yosef

"Peo Sjoblom" wrote:

Regarding MROUND, you can get the same result using built in functions
but we need to know how you want to round first

--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file

and
since its an ADDIN in the analysis tool pack many users of my file get

errors
! Is there a way around this without making them install the add-in

?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same

version
excell as I do - and this is causing an error message to appear.

Can
this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked

cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great.

But the cell
its linked to - which is also formatted as % to 3 decimal

places
wont format
as a % - and thats a displayed cell so I need it to format

properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson







ynissel

Combo Box - HELP
 
Perfect - thanks so much !!
Any thoughts on why my conbo box formatting isnt working on some people's
machines ?

"Peo Sjoblom" wrote:

Yes

=ROUND(A1/0.125,0)*0.125


--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
I always need to round to the nearest 1/8th.
So my function is mround(a1,.125)
Is there a built in function that can do the same thing ?
Thanks,
Yosef

"Peo Sjoblom" wrote:

Regarding MROUND, you can get the same result using built in functions
but we need to know how you want to round first

--

Regards,

Peo Sjoblom

"ynissel" wrote in message
...
Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file

and
since its an ADDIN in the analysis tool pack many users of my file get
errors
! Is there a way around this without making them install the add-in

?
Thanks,
Yosef

"Dave Peterson" wrote:

What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same
version
excell as I do - and this is causing an error message to appear.

Can
this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked

cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great.
But the cell
its linked to - which is also formatted as % to 3 decimal

places
wont format
as a % - and thats a displayed cell so I need it to format
properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson









All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com