Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.31 seconds.

  1. Re: ComboBox,select case all working except one column not showing

    looks like you are asking a new question & probably better to start new thread (You can add link to this thread) where likely get more responses.

    Dave
  2. Replies
    16
    Views
    347

    Re: Check if date is in future and empty textbox

    DateValue recognizes the order for month, day, and year according to the Short Date format that you specified for your system

    So if you enter 10/13/2019 in your textbox, DateValue should, I would...
  3. Re: how to get combobox multiselect results to specific worksheets

    Hi,
    Just a guess but maybe



    Private Sub OKButton_Click()
    Dim ws As Worksheet
    Dim i As Integer
    Dim LastRow As Long
    Dim lb As Object
  4. Re: ComboBox,select case all working except one column not showing

    welcome, glad suggestion resolved issue

    Many thanks for feedback


    Dave
  5. Re: ComboBox,select case all working except one column not showing

    Hi,
    try this update



    Private Sub ComboBox1_Change()
    Dim Index As Integer
    Index = Me.ComboBox1.ListIndex
    With Me.ComboBox2
    .RowSource = ""
  6. Replies
    16
    Views
    347

    Re: Check if date is in future and empty textbox

    Hi,
    same thinking as Yongle about USA dates

    try changing this line



    If CDate(.Value) > Date Then
  7. Re: ComboBox,select case all working except one column not showing

    Hi,
    welcome to forum

    Untested but see if this update to your codes will do what you want




    Dim arr() As Variant
    Private Sub ComboBox1_Change()
  8. Re: Check if sheet exists while looping through workbooks

    All that bit of code does is return a boolean value - True is sheet name matches variable value otherwise False

    welcome - Glad resolved

    Dave
  9. Re: Check if sheet exists while looping through workbooks

    Try replacing your function with this updated version & see if resolves the issue



    Function WorksheetExists(ByVal shtName As String, Optional ByVal wb As Workbook) As Boolean
    Dim sht As...
  10. Re: Check if sheet exists while looping through workbooks

    In that case the function should return False.

    Do not have much time to test your function but see if with few changes to your main code, you can do without it




    Do While myfile <> ""
    ...
  11. Re: Check if sheet exists while looping through workbooks

    Hi,
    try



    Do While myfile <> ""

    'Set variable equal to opened workbook
    Set wb = Workbooks.Open(Filename:=myEXPPath & myfile)
  12. Re: How to save a file using "if then or else" in case the 1 drive is not found

    Hi,
    try this update



    Sub InvoiceReport()
    Dim myFolder As String, myFileName As String
    Dim SharedFolder As Boolean

    myFolder = "Z:\HLEKTRONIKH TIMOLOGISH\INVOICE MANAGER"
  13. Re: How to save a file using "if then or else" in case the 1 drive is not found

    Hi

    welcome to forum

    See if this change to your code does want you want



    Sub InvoiceReport()
    Dim myFile As String
  14. Replies
    9
    Views
    230

    Re: Timesheets and Userform

    You are not the first to do this but should always use any code updates complete & unaltered in first instance.

    Glad your issue now resolved

    Dave
  15. Replies
    4
    Views
    42

    Re: Hiding rows which have a check box

    Good solution

    Dave
  16. Replies
    4
    Views
    42

    Re: Hiding rows which have a check box

    Have a read of this article:https://www.extendoffice.com/documents/excel/3697-excel-hide-checkbox-with-row.html#a1

    & see if any help to you

    Dave
  17. Replies
    9
    Views
    230

    Re: Timesheets and Userform

    did you copy all my code as published or have you just amended your existing code?

    Dave
  18. Re: Copying AND pasting (transpose) from multiple workbooks to one master workbook

    Hi,
    welcome to forum

    Have a look at Ron de Bruin site here:https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2007/cc837974(v=office.12)?redirectedfrom=MSDN

    and see if...
  19. Replies
    2
    Views
    111

    Re: Open userform when worksheet opens

    hi,
    try



    Private Sub Workbook_Open()


    With Worksheets("INCOME (1)")
    .Activate
  20. Replies
    9
    Views
    230

    Re: Timesheets and Userform

    Its always helpful to share information like this when requesting assistance.

    Try this change to the code



    Private Sub UserForm_Initialize()

    'PURPOSE: Initialize the Resource UserForm...
  21. Replies
    9
    Views
    230

    Re: Timesheets and Userform

    Does it error on this line




    Set sh = Worksheets("shSummary")


    If so, the worksheet tab name shSummary you stated you have, does not exist.
  22. Replies
    2
    Views
    126

    Re: SaveAs macro bug needs fixing

    Hi,
    try



    Dim FileSaveAs As Variant

    ChDrive ThisWorkbook.Path
    ChDir ThisWorkbook.Path
  23. Replies
    9
    Views
    230

    Re: Timesheets and Userform

    Hi,

    Untested but try following & see if does what you want



    Private Sub UserForm_Initialize()

    'PURPOSE: Initialize the Resource UserForm
    'Show the date and day at the top of the...
  24. Re: Copy cell value from a different workbook into a textbox in a userform

    The TextBox change event triggers went you type something in to it - You want a value returned to that textbox from another workbook which code provided should do, but you something needs to happen...
  25. Re: How to copy cell vaule from a different workbook into a textbox in a userform

    I suspect you are using the wrong event for what you are trying to do. Assign that code to a button on your form & see if returns value you want.

    dave
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4