Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Userform which does a LOT of calculatios but I´m using the direct
data from the Textboxes like this : me.sbad.Value = Val(Me.sba) / Val(Me.tc) me. cad.Value = Val(Me.ca) / Val(Me.tc) Like these calculations I have a couple of hundred in the whole userform, but then I have a button to display each result in a Worksheet, but it takes for ever to copy it to the worksheet, well like 20 seconds, But still its a lot of time just to copy and paste it to a worksheet. I was wondering why is this happening ? and would it help if I use variables for all the calculations instead of the textboxes. Like this: Dim salary as integer dim wage as integer dim rate as integer salary= me.sba.Value wage= me. ca.Value rate=me.tc.value me.sbad.Value = salary / rate me. cad.Value = wage / rate Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Assign a variables value to a TextBox | Excel Programming |