Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help pls! I need a procedure which can help me to select a selection A and B
respectively, so that selection A is chosen every other time the procedure runs (and the same for selection B). I intended to make a procedure that sets the flag to TRUE when the flag is FALSE and vice versa. In the code presented below, the boolean value remains FALSE and never changes to TRUE. What I am doing wrong?? Public Sub Insert_Flag() Dim Worksheet As Worksheet Dim Flg As Boolean Set Worksheet = ActiveSheet Select Case Flg Case Flg = True (Selection A) Flg = False If Flg = False Then Cells(1, 3) = False Case Flg = False (Selection B) Flg = True If Flg = True Then Cells(1, 3) = True End Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"acessor flags" creating pivot table from recordset | Excel Programming | |||
Can a "flags" or "reminders" be used in a ws | New Users to Excel | |||
LOOP BETWEEN "FRONT" AND "END" SHEETS? | Excel Programming |