Is it possible to write VBA code to detect the style currently used? I am creating a macro to insert and format a table and image caption, however the style used for these captions depend on where it is in the document e.g. the caption sits further in if there is a heading above, for paragraph text I have created an 'indented normal' style, so I am wanting the code to see the 'indented normal' and apply an 'indented caption' style.

Yes it is possible but you haven't provided enough information in order to create the code.

How is the macro going to work out which section it is in? The macro can look backwards or forwards to see if a certain piece of content is above or below it but we don't know what this logic is from what you described. The 'heading above' may be one or more paragraphs above and we don't know what the scope of that is yet.

Maybe you should post a sample document showing what it is you want to achieve and what the styles are that should be factors

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Andrew, I am ok to apply a style, I just don't know how to write the code to determine what style is being used on the active selected text.

It is pretty much the same way. At its simplest you could follow this pattern
If your selection includes multiple styles (eg more than one paragraph selected or character style + paragraph style) then you may need to complicate the code to get the right results.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Nicole. I have a slew of utility procedures for manipulating styles. The attached function may give you some ideas.
This is a self-testing function; drag the commented macro outside of the function then de-comment the macro. Run the test macro until it works, then make changes to the function and insert new test lines and rerun the test macro. Comment the macro and drag it back into the function.
Cheers, Chris

Attached Files

Public Function blnStyleFoundInUseI.txt (1.5 KB, 9 views)