I dont want to increase decimal, but this happens when I want to manupulate textbox2 in the attached file. Can u help me with this pls.
I dont want to increase decimal, but this happens when I want to manupulate textbox2 in the attached file. Can u help me with this pls.
Hi Maryam
Long is an Integer data type. Use Single or Double if you need to use decimal places. Use the Round function if you want to limit the displayed decimals.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
hi. lol! yes I made a mistake and defined it as long! you know under multipage_change I put dim x as long and then I didnt put anything for other events( textbox_exit) and I was getting different results. I think in other events it was considered as double.