Posts by dejayajay

  • Applying Mask For Date Entries

    Re: Applying Mask For Date Entries


    Macros were enabled. Now when I try to use one of my regular macros eg 'Merge NextSixCells', I get the message "Complile Error: Invalid Outside Proceedure". Re your other questions, I have 'de-formatted te cells in question, back to General Format. And I amended the code to match your copy above - added Option Explicit at the top, and End With / Application.Enable Events = True / End Sub at the end (without the '/'s).


    But that's it for me for tonight. I'll check back tomorrow. Thanks.

  • Applying Mask For Date Entries

    Re: Applying Mask For Date Entries


    hgus393 has kindly posted the link in his reply. I have replied to another response. Now waiting for more assistance. Will check again tomorrow. Thanks, and good night for now.

  • Applying Mask For Date Entries

    Re: Applying Mask For Date Entries


    Thanks for your reply. To check, I went tools/macros/VBE/view Project Explorer, then double clicked the Sheet for the workbook. The code is there as I placed it. I haven't modified the code at all. The cells that I am entering the date in are all in Column A. Should the macro now work automatically when I type in the dates as say 010107 for Jan 1 2007? I have the cells formatted to dd/mmm/yy. Please excuse my lack of knowledge.

  • Applying Mask For Date Entries

    I'd like to enter dates without having to use the forward slash symbol between the day, month and year values. I've read a post by Dave Hawley explaing how to do it, but I can't get it to work for me. There must be some step that I am not aware of. Help please.

  • Command Button Link To Open Sheet(s)

    Re: Command Button Link To Open Sheet(s)


    I managed to get the problem solved via your earlier reply, but this one has me stumped. I pasted the code into a new Control Button as suggested, and changed the name of sheet 1 to MENU. Presumably that would be critical. But it isn't working for me. I an interested, as it sounds from your description that it will somewhat automate the process of adding the buttons and links. Care to keep trying with me?

  • Command Button Link To Open Sheet(s)

    Re: Command Button Link To Open Sheet(s)


    The work book will have more sheets than I can see on one screen, and I wanted a way to get them all listed and accessible from one page. Plus I wanted to see how to do it anyway. So thank you for your quick reply.

  • Command Button Link To Open Sheet(s)

    I am trying to create a sheet with 'buttons' on, a bit like a 'linked table of contents', that will take the user to individual sheets (as opposed to clicking on the sheet tabs). I can see how to place Command buttons on a sheet (in this case Sheet1), but I think I need help with the code to make the buttons function as I envisage. Is this in the scope of help via this forum?

  • Selecting cells and merging, with VBA

    Re: Selecting cells and merging, with VBA


    Thanks for your reply - As you suggested, I played around with the offsets, and got the required cells to merge, which was actually the cell down one and THEN the cell across one. Now I need to make the the newly merged cell the active one. Can you help with this too? I feel like an extreme novice - my questions pale beside all the other posts! But thanks a million. If you are ever on the Gold Coast...