I have been given a spreadsheet to modify,(original author has retired) it has an object that you click and it either inserts a value of 0 or the "Standardweight of 216 lbs.
I need to modify the code to reference a cell value eg. in cell C1 the following formula A1-B1 = (required value for the Const value in the below code)
" Option Explicit
Public std_wt As Integer
Const StandardWeight = 216
Const sw$ = "216"
Many thanks for any assistance
I need to modify the code to reference a cell value eg. in cell C1 the following formula A1-B1 = (required value for the Const value in the below code)
" Option Explicit
Public std_wt As Integer
Const StandardWeight = 216
Const sw$ = "216"
Many thanks for any assistance