objects vba

To provide me with a way to learn VBA I am creating an exercise workbook. I have a form setup with three initial fields, a textbox that tracks an action ID, dropdown with pre-defined list for action type and finally, action duration. The idea is I would enter an exercise, such as "Run for 2...

FolderLoc = FolderLoc & "" & "Jan" & ". " & Year 'Inside the Folderloc there are ten's of file and each and every files has atleast three more files in it. Set FSobj = CreateObject("Scripting.FileSystemObject") Set ProjectsFolderObj = FSobj.GetFolder(FolderLoc) For Each BCFolderObj In...

Hi everyone, I got this data mining code from here: Opening and Extracting Data From All Files in Root and Subfolders The way the code works now is if you enter the filenames you want to mine data from, it will find them for you and list them next to the filename. My problem is, I want to be...

Hi All, First post here. I've spent 3 hours trying to figure this out and just can't do it. Basically I have a UserForm in WORD VBA with the Excel Reference added onto it. I have named my UserForm under properties (Name) to formStage1. Now I have a whole bunch of command buttons and which...

I was working on a presentation for work where I wanted to build a 'Family Feud' type board to play a game. In the board I am using activex text boxes with code that would hide the text box to reveal the answer underneath or it would show a custom shape (an X in a box) and play the buzzer...

I’m confused about bjects named: “sheet” and “sheets”. I understand that Sheet refers to a specific worksheet but “sheets” can refer to either worksheets or chart sheets. How does XL know which object is being referenced if “sheets” can mean either. And why have an object named “Sheet” if...

Hi all, I've been stuck on this problem and it's killing me now! I basically have a code which creates drop down list objects. The code below essentially creates 2 rows and "Selection.Offset(0, 8).Value" columns (which is a cell 8 columns to the left that contains an integer value) of...