command buttom formula

[Quicksnot]

Hi thanks for taking the time to read my post

on my form i have 2 command buttons NEXT and DONE

believe it or not i figured out the DONE button on my own LOL,

but need a simple formula for the NEXT button which clears TextBoxes and OptionButtons

Thanks
Keith

[Winon]

Hi Quicksnot,

It is actually very easy. View the code I have entered for the "Next" button to deal with Textboxes, and then just add the same format for the OptionButtons.

[Quicksnot]

this is what i used after looking for ideas on the web
it seems to work, but you being a whole lot better at excel then me, maybe theres a problem with
it that i don't know of.

if this code is ok please let me know.
you guys are a great help to me, theres only 1 thing left to do and my prodject is complete.
that all the information that the form puts on sheet2 "PLAYERS", goes to sheet3 "TOTALS"
and it can do a running total next to their names

Thanks
Keith

Please Login or Register  to view this content.