Formula

[Deb]

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?

 

[macropod]

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/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

Cheers

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?