visual basics

Hello, I have a solution to a problem which I do not have the knowledge about VB to get there. My issue is I have a inventory count with a Button that I'd like to allow the user to click and be able to upgrade copy and paste by accessing a closed Inventory log workbook looking at a column...

For my table of column cells, I'd like the checkbox(form control) in each cell to be checked/unchecked with a click of a macro button (form control). i.e, for (each table column H cells checkbox) if (not checked) check else uncheck From search, I found that people use the name of...

I didn't really have a need for VBA until now, but I do have a lot of experience writing formulas in Excel. If someone could help write a VBA code for me to simply copy and paste, I'd really appreciate it. Essentially, I have a date in D5 and a date in E11. If the dates match, I need row 25 to...

I'm a novice at VBA and am using the immediate window. I am getting a Run-Time error '1004': Application-defined or object-defined error and I don't know why. I have the following code in my immediate window. I have a similar code, but for the Income Statement which works just fine. I...

This is part of my specifications and I am having trouble with it. When converting from one language to another: a. The words to be converted must be placed into an array with each element of the array containing one word. b. When converting the words, each word must read from the array and...

Anyone does have idea what or how to edit the code when AS400 change/update the version from 5.1 to 5.9? Thanks in advance! :)

Hello, Your help would be really appreciated! I have an excel file which reports corporate data and includes a macro. The macro copies and pastes a range into the body of an email. I've been using this code for over 3 years and this is the second time this happens in two separate files. I...

I'm using a workbook with multiple sheets of data... Trying to insert pictures onto Sheet 1 (horizontally across a row - cells A1 thru F1) using external references found on Sheet 2 (located in vertically in Column A, rows 1 thru 6) - see below: <colgroup><col width="64" style="width:48pt">...

Hi My objective: I have embedded a Shockwave Flash Object in an Excel sheet, and can manage to link and play video from one URL address– see video example here (How to embed YouTube video into an Excel spreadsheet - YouTube). However, I like to use/link the same Shockwave flash object to play...

Please can I get some assistance on the following: 1. Look for duplicates rows throughout the different worksheets using the value under column A (excluding A1). 2. If there are duplicates, ensure that all the possible values combine are listed (excluding duplicate values but including...

i trying to protect my excel workbook so no one can copy or edit my work,i have successfully disable all main sources of copying my work such as,"right click" on the mouse is disabled and "save as" is also disabled. "ctrl+c" also disabled,but I've notice that when i click the menu key( context...

Hey guyz, thanks for this amazing blog. I am a newbie to visual basic and i would really appreciate if you could help me with my stupid problems... I am creating a database for brain tumors in excel spreadsheet. So, i am using VBA Userform to add the data. I have attached an image of the first...

I have a row of values that I want to export to different targets on different sheets. SHEET 1 A1 A2 A2 A1 Exported to Sheet2!B17 A2 Exported to Sheet3!B17 If that example above helps. Thanks in advance!