condicional formating macro?

[chobanne]

hi all i need help. i have 3 cells A1 B1 C3. I need to have some text i wrote in them only if i use one macro i made. if i dont use that macro it will stay empty. Is this posible? If it is can u help me plese. Thank you.

 

[villy]

Well it is not really clear for me what do you want to do but as far as I understand your case is possible...
What your macro is doing and what text do you want to write in 3 cells?

 

[mikerickson]

I'm not sure what you want. Could you explain it by describing what actions the user takes and what results those actions have?

 

[chobanne]

I'm not sure what you want. Could you explain it by describing what actions the user takes and what results those actions have?

ok i have A1,B1,C1 cels with simple questions in it, but it will only be activated if i run some macro who actyaly dont do anything what is connected with those cells. first i have sheet 1 with nothing on this cells. if i turn button macro 1 it will unhide sheet 2, second - on sheet 2 when i activate another button macro he will calculate something , hide sheet 2 and make sheet 1 again activate and in cells a1, b1, c1 make those questions visible. i hope you understand. it looks like conditional formating who will be activated only if macro 2 is activated. only if i get back from that macro to sheet 1.

 

[mikerickson]

So what you want is:

The user sees Sheet1, with A1:C1 blank.
The user presses a button
Sheet 2 appears
The user presses another button
Sheet 1 re-appears, this time with some questions in A1:C1

Is that what you want?

If so,

Sub Button1_Click()
    With ThisWorkbook.Sheets("Sheet2")
        .Visible = xlSheetVisible
        .Activate
    End With
End Sub

Sub Button2_Click()
    With ThisWorkbook.Sheets("Sheet1")
        .Activate
        .Range("A1").Value = "Question 1"
        .Range("B1").Value = "Question 2"
        .Range("C1").Value = "Question 3"
    End With
End Sub

Its not clear how Conditional Formatting applies to your desired result.

 

[chobanne]

So what you want is:

The user sees Sheet1, with A1:C1 blank.
The user presses a button
Sheet 2 appears
The user presses another button
Sheet 1 re-appears, this time with some questions in A1:C1

Is that what you want?

If so,

Sub Button1_Click()
    With ThisWorkbook.Sheets("Sheet2")
        .Visible = xlSheetVisible
        .Activate
    End With
End Sub

Sub Button2_Click()
    With ThisWorkbook.Sheets("Sheet1")
        .Activate
        .Range("A1").Value = "Question 1"
        .Range("B1").Value = "Question 2"
        .Range("C1").Value = "Question 3"
    End With
End Sub

Its not clear how Conditional Formatting applies to your desired result.

yeah u got the point but those macros are not only for this... they do other stuff, but now i got idea so thank you very much