Menu

making a checkbox appear and disappear based on a cell's value

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Posted to microsoft.public.excel.programming

yoram

yoram is offline

external usenet poster

Posts: 22

Default

making a checkbox appear and disappear based on a cell's value

Jan 23, 9:22 am show options

From: " - Find messages by this
author
Date: Mon, 23 Jan 2006 15:22:13 -0000
Local: Mon, Jan 23 2006 9:22 am
Subject: making a checkbox appear and disappear based on a cell's value

Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

i know this might have been addressed before but i cannot get the
following code to work. basically i want a checkbox to appear if cell
A1 is = "abc" and disappear if it is anything else. this checkbox was
created from the controls toolbar. so i started off the checkbox set
to invisible and then have an if/then statement to make it visible.
what am i doing wrong? right now the checkbox will not reappear.
thanks in advance for any help.

Private Sub Worksheets_Calculate()
ActiveSheet.CheckBox15.Visible = False
If Worksheets("Sheet1").Range("A1").Value = "abc" Then
ActiveSheet.CheckBox15.Visible = True
Else
ActiveSheet.CheckBox15.Visible = False
End If
End Sub

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select a cell based on an other cell's value	wally_91	Excel Worksheet Functions	4	March 13th 08 12:24 AM
Change value based on another cell's value	mainemike	Excel Discussion (Misc queries)	1	March 7th 06 06:36 PM
Making a cell's contents lower case	KimberlyC	Excel Worksheet Functions	4	May 4th 05 11:23 PM
Varying a macro based on a cell's value	Neal Zimm	Excel Programming	4	December 27th 04 06:37 AM
Worsheet Name Change Based on cell's value	nuver	Excel Programming	12	May 29th 04 04:26 AM

All times are GMT +1. The time now is 09:30 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement