Home > Excel Help Portal > Excel and the Web

<<  (Page 3)  Previous              Next  (Page 1)  >>

Excel and the Web

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses topics about Excel and
the Web.

151. Programming a messagebox for user responses Use a MsgBoxIf MsgBox("My Question", vbYesNo,"Title") = vbYes then 'Do somethingElse 'Don't do anythingEnd If MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of... Keywords: Macro, VBA, Hyperlinks, Web

 
152. Delete a worksheet in a macro without having to see the "This worksheet will be permanently deleted" This particular message is one that can be suppressed by using the Application.DisplayAlerts property. Use the following code:Application.DisplayAlerts = FalseWorksheets("MySheet").DeleteApplication.DisplayAlerts = True MrExcel.com provides examples of Visual Basic procedures for illustration only,... Keywords: VBA, Web

 
153. Rounding Numbers This is one function that I like very much ! If the number is in A2 just use this formula=CEILING(A2,500) MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of... Keywords: VBA, Web, CEILING

 
154. Switching between active worksheets Sure, a couple listed below:Control Tab or Control Shift Tab: Switch between windows (Or workbooks)Control Pg Down or Control Pg Up: Roll between worksheets in a Workbook. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied,... Keywords: VBA, Web

 
155. Run a Macro Automatically When the Workbook Opens Place something like this in the Workbook... Keywords: Macro, VBA, Web

 
156. Macro to Save File as name in A1 Arcangelo from Italy asks: How can I write a macro to save the current file with a filename from cell A1? This macro is amazingly... Keywords: VBA, Macro, Web

 
157. Changing the Text Size in Excel's Help Excel 2000 and later use HTML Help to display help topics. If you find that the text size is too small (or too large), you can easily change it. If you have a wheel mouse, press Ctl and spin the wheel to change the text size. Make sure that the text window, not the contents window, is active. If... Keywords: Charts, Format, Formulas, Printing, HTML, Internet Explorer

 

<< (Page 3)  Previous              Next  (Page 1) >>