how to dimension variables as %

**napo537** · 06-03-2010, 10:50 AM

Hi, i have just get in to the wolrd of macros, andi i need some help.

I did a workbook, with 10 worksheets, those are related with formulas and they give results in each worksheet and in one worksheet that i called RESUME, to collect all the most importants cell outpouts. So i did a user form to put data inlets, in diferent cells in diferent worksheets, but, some of them are percentaje form, and i don`t know how to dim this variable.

hope you can help

thank you

**romperstomper** · 06-03-2010, 11:01 AM

There is no Percentage type - you should use a Double and format the cells to display as percent.

**napo537** · 06-03-2010, 12:45 PM

Originally Posted by romperstomper

There is no Percentage type - you should use a Double and format the cells to display as percent.

Could you please be more specific?, i have no idea how to di that.

And how could i, put input data, in a worksheet in a diferent cell.

it appears to work fin if i put this

sub X

worksheets(1).Range("c8").select
activecell.formulaR1C1=textbox1

end sub

**if im the activesheet is number one, it changes its value, but if i want to change a value in a diferent sheet, even though i put worksheet (2) o any value, it doesn`t work

Thank you in advance

**romperstomper** · 06-03-2010, 02:19 PM

You don't need to select - you can just add the data directly. For example:

Please Login or Register  to view this content.

**napo537** · 06-03-2010, 05:37 PM

Originally Posted by romperstomper

You don't need to select - you can just add the data directly. For example:

Please Login or Register  to view this content.

I did wath you said, it worked, in fact i use your sintax to figure out how to put in some currency data, and now thank to you i can put the data in every sheet that i want.

I will try to continue programming this userform, now i have to try out with optionbuttons y checkbox, putting some if functions to select some cells or to put some data in some cell depending on the optionbutton selected o checkbox marked.

thank you very much.

we`ll keep in touch