RE: Rethink in design of document / vba coding help please

Here's one approach for creating a pop-up list in a field (from the mvps site):
http://word.mvps.org/faqs/tblsfldsfms/AutoTextList.htm
You could then use the contents of that cell in your calculation macros.

However a bigger question is whether you should migrate this work to Excel
and let Excel do the calculations for you? Seems like an awful lot of work
to replicate spread*** functionality in a Word table.

IMHO Word tables are fine for text but not so fine for calculation...

--
Chuck Henrich
www.ProductivityApps.com


"Nick Calladine" wrote:

> I have produced a document for a friend which has a table for data and a
> table for totals
>
> My document basically is all done as word and using the vba to do
> caculations and check data in the table for integrity.
>
> This has worked fine for the last year but now he needs another controlling
> element... and I am not sure if you be thinking of writing the input section
> in to a form rather than directly to the table.
>
> I basically now need to add a combo box to each row of the table all the
> combo box will be doing is offer choices of calculating the data
> ie dropdown1 = vat thus add vat to the totla
> dropdown2 = cis4 add vat to the gross wage and then -18% of the gross
> wage and add together
> dropdown3 = cis6 -18% off the gross wage
>
> but i thought if i can get this right if there is further type of deduction
> / calculation required it just gets added on part off the dropdown
>
> so firstly is there a better way should i be using a form to input data and
> then put it to the table.
>
> Is it ok to have a table which has a column of the same repeated dropdown in
> each row.... how can i achieve this.. .as i have not embarked in repeating a
> single dropdown on the same page before
>
> Another point to remember is the document core data doesnt change all that
> often
> ie a man joins the company every week he will get paid thus his deduction
> details will be the same everyweek after being created ; also his name wont
> change ; his job number wont change
>
> Please advise how i should be looking at the project now as i think i might
> a bit more of application rather than document manuliation.
>
> All advise is welcome and if people have any examples of similar things so i
> can see how visualy they have intergrated them that would be a great help...
>
> Many Thanks
>
>
>
.