Posts by PieterGrove

    I have created a command button to randomize a series of numbers. No issues. I am looking for a code that auto randomizes these numbers (once only) on a specific day of the month.

    Code is as follows:

    Hi vcoolio,
    Thanks for your reply, but I think I may have been a bit vague. Sorry.
    Here Goes: In Sheet 1 Column A I have dropdown boxes created by data validation referring to Sheets 5 and 6. The dropdown box related to sheet 5 auto generates a comment box based on data in columns B, C,D,E in sheet5 . I would like the dropdown box related to sheet 6 to also auto generate a comment box based on data in sheet 6. Hope this makes sense. Please find attached example

    I have the following code as listed below, no issues.


    [SIZE=13px]Problem is I want this code to refer to more than one sheet, for example sheet 5 and sheet 6. Any Suggestions?[/SIZE]

    Hi there,

    I have a basic data sheet 1 with rows numbered from 1-31(Column A). Column A represents days of the month and have relevant data in Columns B to J
    Would like to have number 1 with relevant data highlight on the first day of the month, Number 2 with relevant data highlight on the 2nd day of the month and so on. Also then have the highlighted row with data show on Sheet 2. Any suggestions please?

    Thanks for all your help jolivanes.

    Double click issue solved, just thought it would be handy not to populate a comment if cell is double clicked by accident
    When I type a name not related to that of the data on sheet2 I still get an error message. On sheet 1 there will be the odd occasion where names are typed in that are not related to those on sheet2.

    I saw a previous thread on this topic but lost data on my computer and for the life of me can’t find it. So here goes:

    I have a workbook with 2 sheets.

    Sheet 2 has four columns named as follows: ( A) Customer Name, (B) Address, (C)Telephone Number and (D) Mobile Number.

    I would like to type a customer name in sheet 1, column A listed in Sheet 2 under column (A) and then have the cell in sheet one auto populate a comment box with the relevant address, telephone number and mobile number.

    Please help.

    Thanks Logit,
    Have tried with both lines, get this errors message: "Object variable or With block variable not set". Deleted the first line and code updates the last row. however when opening the form again the form shows the 10th last row on my sheet and not the last row. Hope this makes sense?

    I have a userform to update the last row. Code works when updating the last row once, problem is once the last row has been updated when opening the form it now jumps to the second last row. How can i adjust my code to prevent this from happening. I would like to be able to edit or update the last row multiple times, but only the last row and nothing else. Any help would be much appreciated.
    Cross posted -…last-row.html#post4949047