Formula

I am trying to do a simple formula of one cell multiplied by another cell on a form/table that has already been designed. Quantity x Cost to =, but I can't figure out what cell I am in. In Excel there was a section that told you what cell you were in A23 or B19. I have tried everything I can think of and it keeps coming back with *Syntax Error - Any suggestions?

Also this table is going to be used by lots of people and I would like to lock some cells so that they cannot change and it would be nice to just hit the tab key and go to a field that they need to enter information in. Any way to do that?

Hi Deb,

MS (I think) produced a macro for returning table cell addresses. The copy I
have uses the following code:

Sub CellAddress()
If Selection.Information(wdWithInTable) = True Then
StatusBar = "Cell Address: " & Chr(64 + Selection.Cells(1).ColumnIndex)
& Selection.Cells(1).RowIndex
End If
End Sub

As for your syntax error result, that may or may not be due to incorrect
cell addresses. In Word, for example, you don't use $ symbols to indicate an
absolute address - cell addresses in Word are absolute by design. If your
Quantity and Cost values are in A23 and B19, for example, the field coding
would be:
{=A23*B19}
where the field braces are created via Ctrl-F9

For more of Word field maths, check out the Word document at:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442
(url all one line)

Cheers

"Deb" wrote in message
...
I am trying to do a simple formula of one cell multiplied by another cell
on a form/table that has already been designed. Quantity x Cost to =, but I
can't figure out what cell I am in. In Excel there was a section that told
you what cell you were in A23 or B19. I have tried everything I can think
of and it keeps coming back with *Syntax Error - Any suggestions?

Also this table is going to be used by lots of people and I would like to
lock some cells so that they cannot change and it would be nice to just hit
the tab key and go to a field that they need to enter information in. Any
way to do that?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004