Generating Dialog Messages thru VBA over Excel

Hot Topic

Sharepoint workflows
SendKeys from Excel
Textbox won't keep new values after workbook closed
Outlook Macro VB - choose second mail box?
Live Communications Server tab does not show up
Excel COMBOBOX data sources
Help with comma separated values in report
Activate a workbook based on a value in a cell in another workbook
Excel autofilter selection criteria referencing the contnet of a cell on another worksheet
Custom Format Data inside a Cell

Microsoft ISV

Input from user form put into specified cell.
Fill word document with fields from Access form programmatically
Updating text in a text box on an Excel Graph
iexplore.exe - Application Error
Is this possible? (newby needs help with creating a macro in Outlook 2003)
Need help writting a script similar to...
Edit DataLabel in Excel charts
Action Pack Question
iexplore.exe does not respond
worksheet_change and data validation

Generating Dialog Messages thru VBA over Excel

Hi Guys and Girls,

Thanks for the help so far.

I'm on the last step.

I need to generate fairly long dialogue messages dependant upon the data the user has entered. A sort of lok up using Inputbox which I understand and Dialogue boxes which I don't.

I'm really stuck,

I just need a little code that goes

if data_entered = XX then .... open this dialogue box containing this text

else if .... open another dialogue box

else if .... another

end.

Is it possible to dynamically load texts to dialoge boxes rather than hard code them

Again thanks for the help so far.

Hamish

Answer this question

Generating Dialog Messages thru VBA over Excel

  • qrli

    Thanks but MsgBox is limted to what Excel offer.

    It needs to be a dialogue box I think.... but how ..

    H.,

  • Dan Waters [MSFT]

    A message box is a simple dialog box. You tell it what text to display, and you can solicit a response by which button the user presses. Not unlike the input box, which you mentioned in your original post, without the data entry box. Look up MsgBox in the Object Browser, and follow that to the help files, to learn more about this simple yet useful tool.

    - Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


  • Davids Learning

    What do you mean by saying it's limited to what Excel offers What are you trying to do that can't be done via MsgBox()



  • xzanti

    Try the function

    Msgbox()



  • Generating Dialog Messages thru VBA over Excel
Answer this question