User choices

[wmbb]

I want to create a word-document with some option buttons for the users to choose some options they want to insert.

option 1
option 2
option 3
option 4

Subsequently I want to use this info in a macro

How do I insert such option buttons ?
How do I use the results (checked/not checked) in a macro ?

 

[SkipVought]

Hi,

"How do I insert such option buttons ?"

Use the Forms menu.

"How do I use the results (checked/not checked) in a macro ?"

All depends on what you want to do.

Please explain in detail, what you want the macro to do. Please use a concrete example.

Please explain what event causes the macro to run.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

Option buttons are not on the Forms toolbar. The Forms toolbar has Checkboxes though. Option buttons are on the Controls toolbar.

"How do I use the results (checked/not checked) in a macro ? "

Checked? Checked sounds like a checkbox. Do you mean selected? Option buttons are selected.

In any case, Skip is quite right. It all depends on what you want to do. Please give us more detail, and in particular, please make sure to answer Skip's last question.

"Please explain what event causes the macro to run. "

This can be very significant, and may alter what could be the best method to do what you want to do...which we do not know.


Gerry

 

[wmbb]

Thank for your response.

I have several text files with info like:
I've a textfile containing the the following data:
The content is varying but the section are always the same...
**********************************************************
no comments

[Measure data]
Name=Customer
LIMS nr=0.000000
Acc. Voltage (kV)=0.000000
Sample Current (uA)=0.000000
Crystal=PET
Element=Mo
Start (A)=1.000000
Stop (A)=0.000000
...
...

[settings]
mean over#=50
Sample Rate=100.000000
physical channels=Dev1/ai1
Input range=1.000000
Visible records=600
...
...
*********************************************************


I want to collect the data out of these files into a table in WORD, and I want the user to choose whether a value out of text files has to be placed in a table as a colom.

My thought was to create a table with the optional colomns;

The user opens a document with several option-buttons...

X name
O LIMS nr
X Sample Rate
O Input range

Subsequently a macro creates a table with the choosen data:

filename name Input range
filename1 name1 1000
filename2 name2 5000
filename3 name3 2500
..
..

I hope it's clear what I want to setup.