in
All Tags » VBA » format (RSS)

Browse by Tags

  • Masked Edit Control format

    Hi, can anyone tell me how to set the masked edit control format as short date format in Excel VBA? I have VB. code as follows: Private Sub DTPickerActual_Change() MskEd4.Text = DateAdd("d", -4, DTPickerActual.Value) MskEd10.Text = DateAdd("d", -10, DTPickerActual.Value) MskEd30.Text...
    Posted to Microsoft Office (Forum) by microsoft on 05-18-2010

  • Formatting a Textbox

    In an XL worksheet I have an assortment of values, both text and numeric...after a transfer of values occursand a User Form is opened, certain of the UserForm fields are automatically filled in via an assortment of VBA routines...so far so good... Here's my dilema...let's say in the first workbook...
    Posted to Miscellaneous (Forum) by microsoft on 05-02-2010

  • VBA script or macro in access to format phone numbers

    I need a VBA script or macro in access to format phone numbers For example phone numbers in the database are in different formats now 555-555-5555 or 5555555555 and the format should be (555) 555-5555 and (555) 555-5555 ext 555 (555) 555-5555 ext 5555 I'm new to vba scripts and will need detailed...
    Posted to Access Coding/Macros (Forum) by microsoft on 04-28-2010

  • Excel VBA Code to Change the Format of a Subset of Points in a Single Series on a Line Graph

    I am writing an Excel 2003 VBA module that updates a statistical control chart. I am running XP Pro on an IBM T42 ThinkPad with 1 MB of RAM. I want to subject each newly plotted point (It's basically a line graph if you are not familiar with control charts) to a series of statistical tests and then...
    Posted to Project Management (Forum) by microsoft on 04-24-2010

  • Saving a filename with the week number of the last sunday

    I'm using this snippet to determine the last sundays date, based on today but I need to save the week as part of filename i.e. that Sunday (22/06/08) lies in the 4th week. so saving it as Junewk4.xls Code Snippet: 1: 2: P = Weekday(Now(), vbMonday) P = Int(Now()) - P --> Open in New Window Select...
    Posted to Access Coding/Macros (Forum) by microsoft on 02-17-2010

  • Format Image with VBA

    What is the proper syntax to format an image as "Behind Text" with VBA. For Example, I have this code: Selection.InlineShapes.AddPicture FileName:=FileName.Jpg Now how can I format that image so that the image is behind text (equivilant to Format | Picture | Layout | Behind Text). Thanks
    Posted to Word (Forum) by microsoft on 02-08-2010

  • VBA format named range as percent

    Hello Excel experts What is the VBA for formatting a single cell, defined as a named range, in percent format? TIA -Jim
    Posted to Excel (Forum) by microsoft on 11-07-2009

  • how to format date and time

    I'm this is simple. I'm trying to format a date and time as: Format(Date, "YYMMddhhmm"). I believe these are the correct format codes per: http://msdn.microsoft.com/en-us/library/73ctwf33(VS.71).aspx . The YYMMdd comes out OK, but the hhmm always comes out as 0000. What am I doing wrong...
    Posted to Access Forms (Forum) by microsoft on 09-16-2009

  • Cell Format via VBA

    Hello Experts, I have a range of numbers in cells A1:A10, and I would like a macro to start in A1, moving down the column and testing the value of each cell, stopping at the first blank cell. In each cell, the macro should change the colour to blue if positive, to red if negative and to yellow if zero...
    Posted to Excel (Forum) by microsoft on 08-17-2009

  • Change column in Excel (VBA)

    Hi. I am having some trouble with a formula. I am trying to apply some formats to a grid depending on what the value of the cell is. I can use a for loop to jog through rows, but have no clue how to jog through columns. I could use two columns to list the the sheet's colums in row 1 and it's...
    Posted to Excel (Forum) by microsoft on 08-16-2009
Page 1 of 2 (20 items) 1 2 Next >