Hi everyone, I have one pretty dumb question that I hope you guys can help me: We use  password to protect access to worksheets. However, the users who know a little bit about macro can go to...

How do you update a text box control on a form using an SQL statement in VBA code.  I want a text box named IncPersonID to update with a value when I click on a command button.  The SQL statement i...

Hi I would like to encode the functionality of the F9 key, i.e force a recalculation of the active work sheet when the user exits a form. My current code for the Exit button: Private Sub c...

I have a spreadsheet for exapmple:       2007 Status of Workdays Type by Work Center for ALL OWAS as of 2006/10/02 07:15                                                                                     Officer                              Enlisted                         WC            Title      Issued      Obligated      Balance      Pe...

I have a macro that searches a sheet for selected rows to sum.  I determine that the starting row is 39 and the ending row is 48.  How do I write the code to insert the SUM(A39:A48) formula into ce...