excel vba code

Hi everyone, I have been trying to solve this Excel VBA code. Please help me! Question: How to pass a Textbox value of any word/sentence (e.g. "Apple" or "Apple is a fruit.") and split it into different cells in a row with single letter each in the cell from the value including the spaces or...

Please help me to write code for below. I have one "Lists" sheet, I need code for G3:G20 Copy and paste as Value in H3:H20 in every second automatic. Basically, i have one "Form" sheet and when i change data in "Form" Sheet i want this data to update in "Lists" Sheet. Thank you, Hoping to...

Dear all, I am very new to VBA. I have a requirement where I need to hide the columns based on the cell values. For Example, Consider J19, if this is empty then the columns from J to CC should be hidden. Then if K19 is empty, it should hide the columns from K to cc. Likewise, it should check...

Hello all and thank you for looking. I have a userform that is intended to allow the user to apply job overages into other jobs that are not over budget. I have an Excel userform with five text boxes that are populated as follows. The user selects a single entry in a listbox (lbxOne) that has...

i have a workbook name as ColorDB and 2 sheets inside that workbook. The Sheets are named as "CNT" and the other one as "PPB". I have a macro button inserted onto the "PPB" sheet. when i click that macro button , i would like to browse and open a .dat file and import the data onto the same sheet...

Hi All I cannot get my head around this one. I need to copy everything in a worksheet after row 1 (as it contains headers) from one worksheet to another (say CSVin to CSVout). I only to copy rows from CSVin where two criteria are met: - Column 'A' starts with the letter 'C' (customer codes...

Hi, I was hoping someone could help me with a VBA code that would combine text and data from excel to a word document. I have unsuccessfully modified & combined code from examples I have found online, and would appreciate any help you can provide. If possible, could you please add comments to...

Hi Everyone, I need some code that will Copy Diffrent Excel Files data and paste into Master file Simply stated, the loop code will open every file in a single directory and, one at a time, will copy/paste to the Master. What I need is the loop code to go through all of the Excel files...

Hi @all, first of all I am not a native english guy, so apologies if my english has mistakes. But I am so much curious how to solve the following problem. Since a few months I am interested in web scraping by using Excel vba. But take a look first at this html Code. I want to extract the...

hi friends, I want to create a menu bar in excel vba user from containing 6 menu and per menu approx 5 items viz in file menu save, save as like wise. can you have any example or file to help me. it will help me in creating utility. currently i have created 2 menu items but that also giving error.

Hi, This is my first post on this site, I hope someone can help. Forgive me in advance, as I am no expert and in the very early stages of learning excel vba. I would appreciate if you could provide any help on the following. Any suggestions of improvement of codes is always welcome too...

Hi, I have not used VBA in quite a few years and I have looked through all the posted questions & answers and tried to combine/manipulate the code but have had no luck. I would appreciate it if anyone could help me with a code to copy the data within a select a row of a worksheet named “Open”...

Hello, I have the following code producing a run time error. It actually works and and gives me the proper output but it also gives me a run time error '13' for some reason. The purpose of this code is when a user chooses a Family Name from a combo box, a field called txtFamilyID is populated...

I am trying to create a macro with parameters: Sub FormatColumns(Optional fUnderscore As Boolean = False) ... End Sub Once the argument is added, the macro name disappears from the macro selection screen once I hit alt + F8. When I take the argument out, the macro is there. I don't want to...

Hey Guys, I am very new to creating functions using Microsoft VBA and hence need your help for the same. I want to create a function which should perform the operation mentioned below. Function IDW(StartValue, EndValue, CurrentPoint) IDW = (StartValue * (Row(EndValue) - Row(CurrentPoint)) +...

I am working with an excel 2010 file that is updated automatically; therefore, the number of rows corresponding to each id is variable (columns A and B). I am looking for a vba code that generates icon-conditional formatting within each id (columns D and E). Currently, the conditional formatting...

I have one Excel Question, i have one excel file in location C:\Users\Chandra\Desktop\Main File.Xlsx and this is my main file. All information include in this file for eg: Main File.Xlsx, Sheet Name "Detail" And i have one summery File C:\Users\Chandra\Desktop\Summery File.Xlsx. Summery Sheet...

Hi Using VBAcode, I want to filter data code which contains public IP Address and copy the filtered data to other sheet. Column contains both string and number. Please see example:- <tbody> ABC http://192.168.44.29:2967 DENIED BCD https://d31qbv1cthcecs. atrk.js DENIED CDE...

Hi all, Hope you all doin good..well am new to this forum as well as VBA.I have a 30+ seperate excel files in one folder.The sheets contains data for a single month for 30+ projets.I want to pull the data into new master file using excel macro.Im trying to create macro .What i need is 1.The...

my front work sheet looks like this or something like it <tbody> today's work day 2/21/2014 total bills total people bar sales food sales 10211 1020 205.22 320.95 </tbody> and my work sheet is named "master" then i have 7 other sheets there names are monday,tues,wed,thur,fri,sat,sun...