vbtab

Hi, I am trying to format a MsgBox string created from and array of cells. There are 3 columns in the cell range the 3rd of which have a % format. Msgbox writes the string as a decimal. Can anyone help with converting the range C2:C6 to a percentage the same as the source. I was trying to use...

hi all, I have my below code which gives me the value after a particular cell value is change. I want to see what was the cell value before and what the value is after it is changed. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Private Sub...

Hello Everybody, I want to write a string in Microsoft Word always in the same position but unfortunately i am not able to do it. I tried first something like Dim PatName As String *70 but for the first loop works but in the second loop the position changes. Dim PatName...

Hi, I have created VBA code in Excel that takes the contents of a recordset and places the data (Date and Area) in the body of an email message. My code looks like this: This code all works great. The problem is that I want to output additional fields ( Date)and Area), and I want the data to...

Hi, i have the code below i was wondering if you can help me with it please, i have entered textbox18, textbox19, and textbox20 anfd this brings back the date into the email but it is in american format how can i change this please in the code? Also after each textbox i have entered a vbtab, but...

Experts: I would like some assistance with tweaking VBA output in a pop-up text box (upon opening Excel)... please see VBA code below: As of now, the pop-up (data) is driven by values in the actual spreadsheet (I didn't know how to attach the sample file). Right now, the labels (A1:A3) are...

I'm copying some data from various places on spreadsheet into a text string on the clipboard, and wanting to manually paste into both a table in Word, and a table in an Outlook email. The problem is that the spcl character vbTab does not seem to be recognised by either Word or Outlook in the...