How to enter a formula in VBA?

[john456852]

I tried to enter a function into cell d6, but it says there is an error
i tried:

Please Login or Register  to view this content.

It says that>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>this ^ should be the end of the statement
why?
:] ???

[shg]

Open the VBE Immediate window, and enter this:

? "=IF(OR(WEEKDAY(C6)=7,WEEKDAY(C6)=1)"1","")" '1","" ',"","")

Does the line that appears look like a well-formed formula?

[john456852]

but how does it know to put it in Range("D6")?

---------- Post added at 11:34 AM ---------- Previous post was at 11:31 AM ----------

and i do not know how to use immediate window

---------- Post added at 11:36 AM ---------- Previous post was at 11:34 AM ----------

hello? danmarsh? nickmax1? SARAH_MUNFORD? do u know?

---------- Post added at 11:46 AM ---------- Previous post was at 11:36 AM ----------

hello? danmarsh? nickmax1? SARAH_MUNFORD? do u know?

---------- Post added at 11:47 AM ---------- Previous post was at 11:46 AM ----------

How do i insert attachment?

---------- Post added at 11:52 AM ---------- Previous post was at 11:47 AM ----------

how to insert file?

[Mordred]

Open the VBE Immediate window, and enter this:

? "=IF(OR(WEEKDAY(C6)=7,WEEKDAY(C6)=1)"1","")" '1","" ',"","")

Does the line that appears look like a well-formed formula?

I'm going to go out on a limb shg and say no.

[Mordred]

I tried to enter a function into cell d6, but it says there is an error
i tried:

Please Login or Register  to view this content.

It says that>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>this ^ should be the end of the statement
why?
:] ???

I don't think you can name your procedure Function, you may be getting errors because the word Function is reserved. Plus, as shg pointed out, your formula is erroneous.

[Marcol]

Maybe ...

Please Login or Register  to view this content.

[john456852]

How is there an error?
and i typed wrong
it is supposed to be "Private Sub CommandButton2_Click()"

---------- Post added at 01:09 PM ---------- Previous post was at 01:08 PM ----------

Thx Marcol

[Mordred]

Marcol fixed your error in the formula.

[Marcol]

Okay try

Please Login or Register  to view this content.

[Mordred]

On your first post, click on "Thread Tools" and mark it as solved.

[Cutter]

@ john456852

Based on your last post it seems that you are having trouble marking your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.