vb code

Hello, I have an excel sheet with several columns.Each column stands for specific historical data. I would like to search in the excel sheetover a search field (command button). A reset command button is planned toreset the sheet after every search and to empty the search field (commandbutton)...

Need help modifying the code below to meet my requirements. Instead of having the InputBox prompt for Vendor No & Vendor Name and then saving to C:/. I would like to code to automatically use the file name I am converting into .CIF and store to a specified folder. Also, need the bottom part...

Hello Everyone, I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this. I now have another task I must do. My boss wants there to be an Error Message...

Hello Everyone, Is there a way to combine data from multiple excel files into one single sheet by appending data? All the files have the same headers. Also these sheets have drop down list and conditional formatting. Is it possible to append the original data with all the conditional formatting...

I have a bit of a complex problem that i have been having trouble fixing. We currently perform alot of data entry and i would like this macro to avoid doing it manually. We recieve a list from our client and in column A is a list of their clients. I need the macro to verify as close a match as...

I am using the following code to calculate the Balance from the data, Balance = Demand - collection Sub DCB() Dim c As Range Dim lRow As Long lRow = 1 Dim lRowLast As Long Dim lRowDiff As Long Dim lRowPortion As Long lRowPortion = 1 Dim bFoundCollection As Boolean With ActiveSheet...

A newbie to VB coding here. I have a small piece of code that has me stumped. I am using Excel 2012. The purchase of the code is to allow the user to enter one Ticker symbol that resides in two Excel sheets. Each sheet has the ticker symbol in column A, date in col B, formula in column C, and...

hi please use the version1.7 to add the vb formula in it. in modmain vb script hi i need to add a vb code in by vb script below eg- 1.data is in c1 out put to c3.,after first 2 digits the following 4 digits c3 =mid(c1,2,4) 2. data in c9, and c16 ,“open and Closed inverted...

I pull weekly alarm reports. Each alarm has a different "Process States". The states include: active, inactive, completed and pending. I only need to see the "Active" alarms. The Process State is in column J. The raw report looks like this. The report is anywhere from 40,0000 to 60,0000...

I have five worksheets hidden in my workbook. All of these worksheets have either "Yes" or "No" written in cell C4. (3-yes, 2-no) I also have a search bar in the form of a textbox and a command button. I want to be able to type "No" in the textbox, click the command button and have the pages...

Is there a way to send the VB code for buttons and macros with the spreadsheet when emailing from within excel? I have a button to send a spreadsheet through outlook, but when the file arrives at recipient the code and macro are not there.

Hello, I've searched to try and find the answer to this question but not having much joy so any help will be greatly appreciated. I'm relartively new to excel VB codes and my seemingly impossible task is shown below: * I have a list of data each one has 6 rows of data. * (Rows...

I have this code on multiple modules: '---Get Short Filename cShortFileName = GetFileName(aSelections(General.nReqNo, 4)) '---Check for a trailing period and xls cShortFileName = GetShortFileName(cShortFileName) '---Set Page Setup and Print Area InsertHeaderFooter() The InsertHeaderFooter()...

Hello Guru's, I am new to this form and VB macro i need help .. I get a file where i have some data , its as below if the total dr is not equal to cr then i want the data to be copied to a new sheet ...how can i create a macro for this ? <tbody> Line Account Desc dr cr dr cr 1 123 test1...

Hi guys, Can anyone help me with this ?? My original VB code is ElseIf brand = "MAC" And year = "2013" Then Profit = 22 / 100 * cost * quantity ElseIf brand = "Rimmel LONDON" And year = "2013" Then Profit = 31 / 100 * cost * quantity ElseIf brand = "REVLON" And year = "2013" Then Profit...

Hello all, I am relatively new to the VB code for Excel macro and wanted to get your advise on the following macro.. '=== CODE START === Sub c_SLCodeThisWk() Dim t As Long For t = 2 To 100 Range("AR" & t).Formula =...

Hello guys, I have this macro code in Sheet1 assigned to a button named Combination. I copied the whole sheet twice and moved to end. So they have the same data content and hopefully the macro in sheet1 will work as well in sheets2 and 3. But it's not. I just copied the code from VB codes Excel...

I have created an excel dashboard that contains two separate traffic light charts. Each traffic light collects its data from a different cell. When only 1 traffic light is showing and the VB code is for 1 light it works. When I add the second light and code I get a "Compile Error: Ambiguous name...

Currently I have a dashboard style excel document used by multiple users on a network, these users require read/write priviledges and as such only one read/write access file can be opened at a time because of the network.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...

Long time viewer, first time poster. I want to build a macro to push a value from an input cell to table on another tab. For the sake of this forum, I made a very simplified version of what I want to do. On my second tab I have a table with TV shows and number of seasons: Dexter 6 True...