CJ
Board Regular
- Joined
- Feb 22, 2002
- Messages
- 77
I came across this site during a Internet [Excel-help/tips search] I have found it very helpful & have learnt a lot just reading through the posting.
Average Excel knowledge - beginners VB knowledge
I have a Excel / VB Type problem which I need some help with!
I have a Time Sheet, cell A6 holds Weekly Hrs, this it’s value is referenced in a hidden a row (20) then it’s value is divided by 10 ie 3:42hrs in B20 The value of B20 is referenced in all of the 31 VB functions built into this Time Sheet. The Time Sheet is issued to users with 37:00hrs in A6, if a user works part-time say 25:00hrs if they type in 25:00hrs in A6 the cells on the Time Sheet the cells are not refreshed, to their new value. If I copy & paste the default value ???? back into the cells the values are refreshed
Is there any way I can get the cells to refresh? after a new value is entered into A6!!!
Preferably I would like
1) A line in my VB Function to refresh the values
or
2) A button on Aprils Time Sheet which when pressed will re-run all 31 functions, which will result in all cell being refreshed!!
If option 2 is required I need detailed HELP
CHRIS
Average Excel knowledge - beginners VB knowledge
I have a Excel / VB Type problem which I need some help with!
I have a Time Sheet, cell A6 holds Weekly Hrs, this it’s value is referenced in a hidden a row (20) then it’s value is divided by 10 ie 3:42hrs in B20 The value of B20 is referenced in all of the 31 VB functions built into this Time Sheet. The Time Sheet is issued to users with 37:00hrs in A6, if a user works part-time say 25:00hrs if they type in 25:00hrs in A6 the cells on the Time Sheet the cells are not refreshed, to their new value. If I copy & paste the default value ???? back into the cells the values are refreshed
Is there any way I can get the cells to refresh? after a new value is entered into A6!!!
Preferably I would like
1) A line in my VB Function to refresh the values
or
2) A button on Aprils Time Sheet which when pressed will re-run all 31 functions, which will result in all cell being refreshed!!
If option 2 is required I need detailed HELP
CHRIS