Search results for query: *

Hi, I have lots of amount of raw data for each category. And I was trying to see if there was any coding available for me to sort my data easier. So, for example, for the following categories: building A, building B, & building C, it contains lots of raw data. Hence, within building A, x =...

Hi, I currently completed building a template that requires many fields to be inputted. However, my concern is that I would like to build a macro that can transfer all the data that I have inputted already in the current template into a new template with the exact same format. One thing to...

Hi, My situation is that there is a cell that contains dropdown list. And next to that cell, there are cells that is formulated so it calculates the values desired. However, I wish to have few exceptions depending on what they choose from the drop down list. Depending on what the user choose...

Hi, I have a button named 'Renew' that contains a macro which transfers the information that has been already filled on the current worksheet into a new opened worksheet by providing the file name into the inputbox that's populated. Every functionality does work fine, however, I was running...

I have created a Data Validation list using Combo box in order to enlarge the font size inside the drop down list. Everything seems to function properly, however, once I protect the worksheet, none of the combo box functionalities seems to work. The following is my code I have...

I'm having a hard time trying to adjust the font size inside the dropdown list. I have made the font size of the entire worksheet larger, however, the font size inside the dropdown list wasn't being adjusted to the font size I wished for. Any idea how to solve this issue? Thanks, tbl3

Hi, I am working on an application form. I have many fields that needs to be inputted. Also, there are mandatory fields that needs to be inputted in order to obtain the final value. However, my concern is that I wish to code a macro that recognizes all the mandatory fields, and once the...

Hi, I am working on an application form. I have many fields that needs to be inputted. Also, there are mandatory fields that needs to be inputted in order to obtain the final value. However, my concern is that I wish to code a macro that recognizes all the mandatory fields, and once the...

Hi, I was trying to code a macro that transfers specified cell information from one workbook to another by creating a Renew button. The desired functionality of this button is to simply copy & paste the information from the current TEMPLATE to a new TEMPLATE (the two templates are identicle)...