Skip to main content

Posts

Showing posts with the label MSExcel

Form (UI) for your excel sheet

  What is VBA, Why Should You Care? Visual Basic  for Applications (VBA) is the programming language behind Microsoft Office Products. It enables a programmer to automate these products. For example, you could write VBA code that enables the user to simply click a button.  The code could then take the graphs, tables, etc. that were automatically created in Excel and produce a slide deck. This slide deck could then be emailed to a set group of users within Outlook. All this can be completely automated. The applications of VBA are mind-blowing, in fact, I have had automated my job using VBA.  What Do You Need You only need Microsoft Excel. A great feature about VBA is that you do not need any other standalone editor, the editor is included within Excel. You can start  creating user forms to get yourself familiar with VBA. I chose a UserForm as an introduction to VBA because it showcases how you can turn an otherwise boring Excel spreadsheet into a Graphical User I...

MS Word/Excel Trick

Create Table without using mouse and menus Do you know It’s possible create Table without using mouse and menus in MS word and Outlook. Here its that… Type the content (+——+——-+——+) in Microsoft Word and press Enter. One row of a table will be created and for more rows you can press TAB. Step 1: +———–+————————+————-+ Step 2: (After pressing Enter having the cursor at the last ‘+’ Result will be like the below one) Step 3: (press TAB to create more Rows) In this ' + ' represents the column borders and ' – ' represents the length of the each column. Just try this & revert back if any problem