Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. 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"
    ...
  2. 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...
  3. 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:
  4. 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...
  5. Replies
    2
    Views
    2,851

    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
  6. Replies
    1
    Views
    1,045

    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...
  7. Replies
    6
    Views
    4,991

    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
  8. Replies
    6
    Views
    4,991

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

    Thanks Jefferson, but there is also a line in the header
  9. Replies
    6
    Views
    4,991

    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
    '
    '
    ...
  10. Replies
    2
    Views
    8,708

    Thanks:thewave:

    Thanks:thewave:
  11. Replies
    2
    Views
    8,708

    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.
    ...
  12. 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...
  13. Thanks Steve - works like a charm:clapping:

    Thanks Steve - works like a charm:clapping:
  14. Replies
    2
    Views
    1,193

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

    Thanks Gary, I need a new pair of spectacles:blush:
  15. 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...
  16. Replies
    2
    Views
    1,193

    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...
  17. 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...
  18. OK guys found Topic 506360...

    OK guys found Topic 506360
  19. 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
  20. Replies
    2
    Views
    998

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

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

    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...
  22. Replies
    2
    Views
    359

    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...
  23. Replies
    2
    Views
    359

    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...
  24. 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
  25. Hi all, once again I am in need of your...

    Hi all, once again I am in need of your collective wisdom. I have a user form in Word 2007. There is a test box called Reason_TextBox. When this text box receives focus, the contents are not...
Results 1 to 25 of 58
Page 1 of 3 1 2 3