Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    202

    Picture button VBA

    I am looking to find out how to add code to my VBA script for when a picture button is clicked

    I have a series of picture buttons which, if I click any one of them runs through a script to confirm...
  2. Replies
    3
    Views
    174

    Re: Convert cell containing time to number

    Thanks all - Issue solved
  3. Replies
    3
    Views
    174

    Convert cell containing time to number

    I have cells that contain sums of time and I need them to show as 00.00 and not hh.mm

    The problem occurs when I have a sum of hours over 24 [for instance the sum of hours for an employee = 50:00...
  4. Copy Data from One Sheet to Another Based on Date Chosen

    Posted to ExcelGuru: https://www.excelguru.ca/forums/showthread.php?9998-Copy-Data-from-One-Sheet-to-Another-Based-on-Date-Chosen

    In my file, I have a sheet that contains the entire roster over...
  5. Replies
    3
    Views
    143

    Run a Macro when cell is changed

    Good Day to you all

    I have a dilema

    I have this code:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$2" Then
    Sheets("Sales").Range("All_Data").AdvancedFilter...
  6. Replies
    3
    Views
    260

    [SOLVED} Re: Copy data between 2 dates

    Dante Amor

    Thank you

    Works perfectly

    Derek
  7. Replies
    3
    Views
    260

    Copy data between 2 dates

    Hi Guys
    What I am trying to do here is to copy data from a sheet [called Full Bank Statement] that is between 2 dates held in A2 & B2 of the sheet and where the data meets the criteria, copy from...
  8. Re: Update a Named Range from a Drop Down Box

    Yongle

    That's perfect

    Thank you
  9. Re: Update a Named Range from a Drop Down Box

    Each cell in column D is linked to a dynamic range called Supplier

    The formula in the Named Range is:

    =OFFSET(Lists!$A$1,0,0,COUNTA(Lists!$A:$A),1)
  10. Re: Update a Named Range from a Drop Down Box

    Thanks but this is not quite what I'm looking for
  11. Update a Named Range from a Drop Down Box

    I have a sheet that contains a Data Validated drop down.

    There will be occasions where the drop down does not contain the required value.

    So, I want to give the user the ability to type the...
  12. Thread: Auto Log In

    by tigerdel
    Replies
    1
    Views
    157

    Auto Log In

    Hi All

    I have Log In Security within a Workbook which is activated by Clicking a button [CommandButton2]. However, what I need is, if a User clicks the other button [CommandButton1] then it will...
  13. Replies
    5
    Views
    238

    Re: Multiselections in ComboBox

    Thanks again

    I have the following code to send the email which fails at sendto = UserForm1.ListBox1.List

    Anyhelp gratefully received



    Public Function SendEmail()
    Dim esubject As String
  14. Replies
    5
    Views
    238

    Re: Multiselections in ComboBox

    Hi

    Thanks for the quick response

    I would prefer it to be a combobox but would be open to using a ListBox if it is easier to do

    How would I code either?

    Thanks
  15. Replies
    5
    Views
    238

    Multiselections in ComboBox

    Hi All

    I am creating an email useform wherethe user may need to select more than one email address to send to

    I have the code below which works perfectly well in a worksheet list but doen't...
  16. Replies
    10
    Views
    203

    Re: Passing data to next empty row

    So now it just overwrites the line added
  17. Replies
    10
    Views
    203

    Re: Passing data to next empty row

    Spot on - works perfectly
    Thank you so much

    Derek
  18. Replies
    10
    Views
    203

    Re: Passing data to next empty row

    I added the code you suggested and it gave the number 502
    This would be because in column A I have a formula copied down to row 501
    I then changed the ws.Range("a" & Rows.Count) to ws.Range("b" &...
  19. Replies
    10
    Views
    203

    Passing data to next empty row

    The code below shows no errors but does not post any data when I click the button



    Private Sub cmbAddEntry_Click()
    Dim LastRow As Long, ws As Worksheet
    Set ws = ActiveSheet
    LastRow =...
  20. Replies
    3
    Views
    217

    Re: Formatting 2 TextBoxes as Currency

    OK so something definitely amiss

    I was going to attach the workbook but I am apparently not allowed to attach attachments

    code now looks like this:

    [code]
    Private Sub TextBox1_Change()
    ...
  21. Replies
    3
    Views
    217

    Formatting 2 TextBoxes as Currency

    Hi Guys

    I have a userform with 3 textboxes on:

    TextBox1 = the user enters gross value
    TextBox2 = user enters VAT Rate as a number [not a percentage]
    TextBox3 = Calculates the Nett Value

    If...
  22. Replies
    4
    Views
    161

    Re: Add data to next empty row not working

    Missing "Else" from code as marked

    Thanks for looking though

    Derek
  23. Replies
    4
    Views
    161

    Re: Add data to next empty row not working

    Hey Jan
    1.Yes the Active Sheet is the sheet to be added to
    2.Unprotect has been commented out because the sheet is no longer protected due to user rights
  24. Replies
    4
    Views
    161

    Add data to next empty row not working

    Hi Guys

    This code is what I am using to add Data recorded from a userform to the next empty row in a sheet

    It was working but now nothing is being added to the chosen sheet

    Do one of you...
  25. Replies
    2
    Views
    276

    RESOLVED: VBA to remove VAT from a Gross Value

    Many thanks
Results 1 to 25 of 40
Page 1 of 2 1 2