Posts by mrbuttons

    Just to add on, here's the full code I designed for the form.

    Can we actually make a textbox data from a userform not editable when it is transferred to a column? I have a textbox that collects current date and time when it's submitted. When submitting the form, user will not be able to write or select any date as it comes automatically. (Refer photo below).



    Code
    1. With txtdateac
    2. txtdateac.Text = Format(Now(), "DD/MMM/YYYY/HH/NN/AM/PM")
    3. End With


    However, user can change the date and time after it has been submitted. The only way I can think of is to lock the cells for editing.


    Are there any options besides locking the column? Thanks for your support!

    Hello everyone,

    I made a simple userform for the purpose of collecting data. I managed to get all buttons working except the submit button. I'm not sure what's wrong but I'm guessing it got to do with the "values" attribute? My code is as per below.

    Thank you for your support! :)

    Hello everyone,

    I have a worksheet containing a set of information and data. In the second worksheet (Worksheet B), I have summarized version of all information from worksheet A which I incorporated the COUNTIF Function to get the simplified version of the data. Each cells in Worksheet B is using the COUNTIF function since they are different to each other.

    I have attached the file below. It would be good if I can get a starting line of code of the first cell. I will pickup the rest of the codes and will continue for the rest of it. Thank you so much everyone!




    Files

    Hello everyone!

    I just started learning VBA script writing and Makros. I managed to write a script whereby I merge multiple excel workbooks into one master worksheet. At this point, I have accomplished one part of the task. However, I couldn't proceed to make the master file to auto-update automatically if I add or change a data to the slave files. Below is the code that I have written.



    My code copies multiple excel files into a single master worksheet. I have changed the code to ensure that the code captures data to be copied within a selected range.


    Code
    1. 'Change cell reference to the starting point of your data
    2. 'For example, if you begin with cell A2 to merge, start your range from A2
    3. 'Change ''A" column on "A65536" to the same column as start point
    4. Range("A2:AZ" & Range("A65536").End(xlUp).Row).Copy
    5. ThisWorkbook.Worksheets(1).Activate


    Is there any functions that I need to key-in within the code to enable the master file to retrieve data automatically if there are changes made to the slaves file? I have tried PowerQuery as a substitute for this but I don't think that PowerQuery has the function to enable the master file to maintain the same layout as what I want and to input photos as well within the file itself (Correct me if I am wrong).

    I am also open to suggestions if there's anything wrong with my code. Let me know if there's anything I can do to improve myself. Thanks everyone!

    Files

    • Test 1.xlsx

      (15.57 kB, downloaded 23 times, last: )