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