Put a button from the Forms toolbar on that worksheet.

Assign this macro (name it what you want) to that button:

Option Explicit
Sub testme()
Dim myCell As Range
With ActiveSheet
Set myCell = .Range("a1")
With myCell
If LCase(.Value) = "cold" Then
.Value = "Hot"
Else
.Value = "Cold"
End If
End With
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


donw13 wrote:
>
> My users have a form that displays specific data from a database. They have
> the ability to change information in the database. Users choose a customer's
> name from a list box, and the form shows the data relivant to that customer.
> One item is called the lead status, and its value is either "Hot" or "Cold".
>
> I want the user to be able to change the item's value from hot to cold, or
> vise-versa, by clicking a button marked 'Change'.
>
> I'm using the Index function to display data on the form, but that can't
> (apparently) change the value of the data in the database....
>
> Thanks in advance...
> --
> Don Woodman

--

Dave Peterson