Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    74

    Re: Deselect value in inputbox

    Ok. Thank you for having a look.
  2. Replies
    7
    Views
    74

    Re: Deselect value in inputbox

    Hi Fluff,


    If I start typing without using the right arrow key, what I type, types over the "92881092 - " that is in the InputBox when loaded.

    I missed this line of code from my previous...
  3. Replies
    7
    Views
    74

    Re: Deselect value in inputbox

    Hi Fluff,

    Here is my code:


    Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

    Dim C As Range
    Dim Response As String
    If Target.Row...
  4. Replies
    7
    Views
    74

    Deselect value in inputbox

    Hi,

    Is there a way of deselecting the value that is in my input box when it opens?

    If so I'd like the prompt to be after the value.

    Any help would be appreciated.

    Thanks
  5. Re: How to get 1 vba code to run on all sheets in my workbook when active?

    Thanks Steve
  6. How to get 1 vba code to run on all sheets in my workbook when active?

    Hi,

    Please can someone help me?

    I would like to run my code via a double click on the activesheet in my workbook.

    I know I can put the code in the sheets individually to run but because I...
  7. Re: Run Time error 28 - Out of stack space????

    Thank you for your help.
  8. Run Time error 28 - Out of stack space????

    Hi,

    Please can someone help me?

    I have the following code which is triggering Run Time error 28 - Out of stack space.

    This is the only code in my workbook as well.

    How can I clear this...
  9. Re: VBA to find the day number of the year from today's date?

    Hi Rick,

    I did, but when AlphaFrog kindly supplied me with a formula I just started recording a macro. I entered the formula in my cell and then I pressed F2 and then enter and that gave me the...
  10. Re: VBA to find the day number of the year from today's date?

    Perfect, thank you.
  11. Re: VBA to find the day number of the year from today's date?

    Perfect thank you.

    Can I ask, can your code be modified so it can add the following please?

    I would like a 9 before the 278 and then 1092 afterwards.

    Is that possible?

    Thanks again
  12. VBA to find the day number of the year from today's date?

    Hi,

    Please can someone help me?

    I would like a VBA code that can find the day number of the year based from the current date.

    Example: today is the 05/10/2019 so I would like the code to...
  13. Re: How to only allow 1 listbox selection at a time?

    Hi,

    Just wat I was after, Thank you.
  14. Replies
    6
    Views
    111

    Re: Modify code to work in 2 listboxes.

    Hi Fluff,

    I seem to of found a solution.

    Do this look ok to you?


    Private Sub UserForm_Initialize()

    i = Application.WeekNum(Date)
  15. Replies
    6
    Views
    111

    Re: Modify code to work in 2 listboxes.

    Hi,

    I'm afraid it's still the same outcome.

    Thanks

    Dan
  16. Replies
    6
    Views
    111

    Re: Modify code to work in 2 listboxes.

    Hi Fluff,

    I've added your code and it works if I select any week number in one of the listboxes but if I open the userform and with your code that highlights the current week, when I press the...
  17. Replies
    6
    Views
    111

    Modify code to work in 2 listboxes.

    Hi,

    Previously I had 1 listbox with the 52 weeks of the year. Listed WK 1 to WK 52.
    I have change my userform now because the listbox was too long.
    I now have 2 listboxes.

    Listbox1 from WK 1...
  18. Re: Find current week number from 2 different listboxes

    Yeah that's sorted it. Thank you.
  19. Re: Find current week number from 2 different listboxes

    Hi Fluff,

    Your code is working still but what I have noticed is when the form is opened the current week number is highlighted in blue but week 1 has an outline around it. When I click on a...
  20. How to only allow 1 listbox selection at a time?

    Hi,

    I have 2 listboxes (ListBox1 and ListBox2).

    When I select something in listbox1, listbox2 deselects and vice versa.

    I have tried these in listbox1 and listbox2 change and click events:
    ...
  21. Re: Find current week number from 2 different listboxes

    Perfect again Fluff, Thank you.
  22. Find current week number from 2 different listboxes

    Hi,

    I had a listbox (ListBox1) with all 52 weeks of the year in and Fluff very kindly supplied me with this code that worked perfectly for me:

    Me.ListBox1.Selected(Application.WeekNum(Date) -...
  23. Re: Is it possible to be able to tidy and make my code quicker?

    Hi,

    Perfect.

    Thank you again for all your help.

    Dan
  24. Re: Is it possible to be able to tidy and make my code quicker?

    Hi,

    Thank you for your code it does exactly what I had asked for but I was wondering if it was possible to also change the column widths as well with the copied cells?

    Thanks again for your...
  25. Is it possible to be able to tidy and make my code quicker?

    Hi,

    I have a list box with the 52 weeks of the year in listed as WK 1, WK 2 and so on up to WK 52.

    So when a week is selected from the listbox all the data is copied from that week sheet on to...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4