I have created a userform to insert 3 numeric values and on click perform the following calculation:
Worksheets("main").Cells(12, 4).Value = (Int(TextBox1.Text) + Int(TextBox2.Text) + Int(TextBox3.Text)) / 3
Yet, when I download and open from intranet it does not work and shows msgbox
"Run time error - 1004" Method 'Worksheets' of object_'Global' failed.
Nevertheless, when I save the excel file locally, this calculation works fine.
Any ideas on my problem?
Thanks in advance!
Bookmarks