short

Hi. I am creating a spreadsheet for product attributes, which will ultimately be used for generating product SKUs. On one sheet of same workbook I created lists for size, color, material, etc. and applied Define Name. On another sheet (same workbook) I created a drop-down list using Data...

Hello, I have this VBA code that I have been using, and I was just wondering if there was a way to consolidate it. It's rather long, and I haven't minded it until I made another addition and doubled the size. The only thing I need to do is make sure I am still able to edit it. (Sometimes, I...

I have a spreadsheet linked to a databse which is a txt file and it is at the following adress: W:\LIDERAN\Demandas_Direcao\PCP\Alocacao\TXT\aloca.txt I'm looking for a way to refer to de file "aloca.txt" without having to be in that address, but at the same path the spreadsheet is. For...

Currently I am using a worksheet that uses hundreds of hundreds of checkboxes linked to their cells. I find this macro is very long for the amount of times I have to use it and is slowing down my program this is the Macro I am using: Sub AddCheckBoxes() On Error Resume Next Dim c As...

I'm have an excel sheet (sheet1) in which a user can enter characteristics about a "group of people". When all the necessary characteristics are filled in about a specific group of people the user has to push a button, so that all the characteristics will be copied to another sheet (sheet2). In...

Hi to all.. I just want to ask if theres a way to enable and disabled 8 textbox in a shorter code (excek macro). below is my code txt1.enable = true txt2.enable = true txt3.enable = true txt4.enable = true txt5.enable = true txt6.enable = true thanks in advance. fucell