Can I use Word built-in dialog in Excel macro?

[Bracha]

I am missing change case function of MS Word in Excel. I would like to
import Word's built-in wdDialogFormatChangeCase box in an Excel macro. Is
there a way or I have to create may own dialog?

MS Office XP (2002)

 

[NickHK]

Not sure what this Word dialog does, but you can easily use the VBA function
LCase & UCase to change the case of strings.
If you must use Word then you will need to use automation to create an
instance of Word, send your send to the dialog and return the value to
Excel.

What are you trying to achieve ?

NickHK

 

[Bracha]

Thank you for your help. This dialog box allows choosing between sentence,
lower, upper, title and toggle case.
That way I could tie it to individual functions that you mentioned. I thing
your isanswer is no and I will have to build the dialog myself.
Thanks again

bracha

 

[NickHK]

Found this, at the bottom of the page:
http://www.xcelfiles.com/Downloads_01.html
Says it is to replicate that functionality in Excel. no idea how good.

NickHK