drop down option

[peerogel]

I am horrible at explaining things so hopefully I do this right. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Cell A1:A3 will be my input values. Cell B1 adds those values. <o></o>
<o></o>
I wanted Cell C1 when B1 was grater than zero to return as FPS.<o></o>
<o></o>
I got it to work by doing the following if function. (=IF(B1>0,"FPS",""))<o></o>
<o></o>
However I also wanted to make a dropdown in cell C1 with two options "FPS" and "MPH". But I read somewhere in the forums that you cannot combine the dropdown and the if formula. <o></o>
<o></o>
So I was wondering if I can get some help. <o></o>
<o></o>
My main goal is to make the drop down in cell C1 with those two options (FPS and MPH). When the values in A1:A3 are entered C1 automatically changes to FPS. Then if I pull down the drop down and Choose "MPH", B1 gets divided by 1.466. <o></o>
<o></o>
or have cell b1 with formatted with to return the value with "fps" and if MPH is selected in change the format to "mph" and somehow also divide it by 1.466. <o></o>
<o></o>
I don’t mind hiding cells, I tried VLookup but im not good at using it and just could not get it to work. <o></o>
<o></o>
Thanks for any help. <o></o>

 

[Simon Lloyd]

Does that work for you?, if it does then all's well

 

[peerogel]

lol..why, it shouldn't??

I kept getting a run time error '13' every time i cleared the cells. Also if if only one of the cells had value (a2 or a3). So far that cleared the error and have not noticed anything else.

 

[peerogel]

One more question if you dont mind. The keep having an issue with the workbook I created with all the equations I need.

I have several tabs with all the equations I need. So I created a menu. The menu has a scroll bar with the types of equations. Then there is a list box with different equations dependent of the scroll bar. So I can select a type of equation and the list box gives me a list of equations available for the type of equation selected.

On the menu I also made it so a picture of the formula appears when an equation is selected on the list box.

And Finally i have a button that takes you to the appropiate tab of the where i have the equation.

Once on the tab (in this case the tab with the radius equation). I also have a clear cells macro that i recorded.

For what ever reason after i pluggled in the macros you created the tab slows down alot when clearing the input cells or clicking the clear cells button i recorded.

Is there just to much stuff going on, in the worksheet? or do you think the worksheet is corrupted somehow or is that just normal.

 

[Simon Lloyd]

Nope

You just need:
Application.Calculation=xlCalculationManual
at the top of your code and the below at the bottom:
Application.Calculation=xlCalculationAutomatic