Argument not Optional

**WesRuss** · 02-25-2016, 04:57 PM

Please Login or Register  to view this content.

Here is my code, for a simple button. I have been playing around with it for hours, so it may look odd.

I am trying to fill in cells, within certain ranges, when the button is clicked, however, I keep getting the "Argument not Optional" error, no matter what I change.

**Norie** · 02-25-2016, 05:42 PM

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**A person in Kingston** · 02-25-2016, 09:49 PM

Wesrus,
A couple of things to get your code working.

Change the subroutine prototype. The normal prototype for a form button is like button3_click(). If you place a parameter in the prototype as you did, then you'll have problems.
Next, since there will be no definition for Tsht, you'll need to define that amoung your Dim as Dim Tsht as worksheet
Next, you'll need to define your range cell also in your Dims as dim cell as range
Last, the line where you set the value of Tsht, must be a valid reference to a sheet. If you want something super simple just for testing, try set Tsht = activesheet

Hope this helps