Search:

Type: Posts; User: Raymond; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    112

    Microsoft Word Field Maths

    Is it possible to round a number down to 4 decimal places for example:
    400,140,000/805,200,000 = 49.69448584202683% - must show 49.6944% not 49.6945%
    Thanks

    Raymond
  2. Values of drop down list dependent on values of another list

    Hi all, been a while since I've needed to use the forum's collective expertise, but I trust you are all well.
    What I want is, in Sheet2, to have 3 drop down lists: "Province", "Town" and "Suburb"
    ...
  3. Thanks RG - I had also queried on another forum...

    Thanks RG - I had also queried on another forum /http://it.toolbox.com/home/ and received the following code from John Madden which does eactly what I want:

    Dim ctrl As Control
    For Each ctrl In...
  4. Thanks RG but how do I limit it to labels and...

    Thanks RG but how do I limit it to labels and text boxes, not all controls?:confused:
  5. Hide all labels and text boxes in a user form

    I have a user form in excel that has a number of labels and text boxes. When the form opens, I want all of these to be hidden and after the user has entered info, then they must be visible.
    Is there...
  6. Replies
    2
    Views
    3,629

    Try not specifying the row height and select...

    Try not specifying the row height and select "allow row to break across pages" - both accessed via the "Row" Tab of the Table Properties Dialog

    Raymond
  7. Replies
    1
    Views
    1,086

    Copy and Rename Sheets Excl 2007

    Hi once again, I hope someone can help. I have a workbook with a sheet named "0001". I wish to copy this sheet "x" times and incremently rename each sheet. For example, copy 4 times and have...
  8. Replies
    6
    Views
    5,312

    Thanks Jeffereson and Paul, have now had to drop...

    Thanks Jeffereson and Paul, have now had to drop that for something else but will try later.

    Raymond
  9. Replies
    6
    Views
    5,312

    Thanks Jefferson, but there is also a line in the...

    Thanks Jefferson, but there is also a line in the header
  10. Replies
    6
    Views
    5,312

    Word 2007: Replace logo in header

    Hi all,
    I have a large number of documents containing a logo in the header. I recorded the following code to replace the logo with a new one:


    Sub New2011Logo()
    '
    ' New2011Logo Macro
    '
    '
    ...
  11. Replies
    2
    Views
    9,029

    Thanks:thewave:

    Thanks:thewave:
  12. Replies
    2
    Views
    9,029

    Using "or" in VBA for Excel 2007

    Hi once again to all the boffins.

    In my worksheet, I have 4 named ranges: PL_CM_1, PL_CM_2, PL_CM_3, and PL_CM_4.

    If the value of any of these is "Yes", I want to have a message box appear.
    ...
  13. Restrict value of cell to Yes or No but must be Yes if a lookup value is Ye

    Hi all, I hope someone can be of assistance.

    I am able to restrict the values that can be entered in cell B4 to "Yes" or "No" by using data validation list.

    However, I also need to ensure that...
  14. Thanks Steve - works like a charm:clapping:

    Thanks Steve - works like a charm:clapping:
  15. Replies
    2
    Views
    1,227

    Thanks Gary, I need a new pair of...

    Thanks Gary, I need a new pair of spectacles:blush:
  16. Concatenate text including quotation marks - Excel 2007

    The following is the result I need:

    ," + ",TEXT(BI_GP_Eq_P_T,"#,##0.00")

    BI_GP_Eq_P_T resides in N176

    The following
    =CONCATENATE("," + ",","TEXT(",N176,",","#,##0.00")"

    and various...
  17. Replies
    2
    Views
    1,227

    Word Commands Word 2007

    Hi once again everyone. I am trying to find a list of Word Commands in Word 2007 as was possible in previous versions. I do not appear to have Word Commands listed under macros as referred to in...
  18. Hi, I often have to change the editing language...

    Hi, I often have to change the editing language of selected message text from English to Afrikaans. In MSWord this is quite easy

    Selection.LanguageID = wdAfrikaans

    How do I do this in Outlook...
  19. OK guys found Topic 506360...

    OK guys found Topic 506360
  20. Hi All, sorry to raise this one again, but is it...

    Hi All, sorry to raise this one again, but is it possible via VBA to check to see if the user has this setting ticked, and if not tick it?

    Thanks

    Raymond
  21. Replies
    2
    Views
    1,060

    Thanks Hans, I'm a bit slow today!...

    Thanks Hans, I'm a bit slow today! http://windowssecrets.com/forums/images/smilies/blush.gif
  22. Replies
    2
    Views
    1,060

    Hi all, I hope you can help mw (as usual) with my...

    Hi all, I hope you can help mw (as usual) with my problem:

    The Data I wish to filter in the attached workbook sits in A6:AD1180. The Criteria sits in B1:B3. It does not filter. If I change the...
  23. Replies
    2
    Views
    384

    Rightclick the control toolbox and select New...

    Rightclick the control toolbox and select New Page. Rightclick the new page's tab and select Rename and type a relevant name.
    Now put a label on your form and format it the way you like.
    Drag the...
  24. Replies
    2
    Views
    384

    Hi all once again. Is it possible to set the...

    Hi all once again. Is it possible to set the default properties for, say, all labels being added to a user form? By this I mean that when I add a new label for example, the Font must be Arial 10pt...
  25. You could use code like this: With...

    You could use code like this:


    With Me.Reason_TextBox
    .SetFocus
    .SelStart = 0
    .SelLength = Len(.Text)
    End With

    Thanks Hans, as usual you've managed to come to my rescue
Results 1 to 25 of 59
Page 1 of 3 1 2 3