View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bull Bull is offline
external usenet poster
 
Posts: 26
Default Help - Easy one - ControlSource Property Invalid

I have a user form (called FilterForm) that pops up when I hope the
sheet called "TRACK";

I put a text box on this userform (FilterForm) that I am trying to
have display the amount of records that I currently have filtered on
the Sheet (Track).

The text box needs to say the number of records currently filter
(SUBTOTAL).

I put in the controlsource: =SUBTOTAL(2,A1:A999), but this gives me an
error.

Assistance requested oh wise guru's.

Bull