vb code

  1. V

    Formula or VB Code in a data sheet

    Hi and Thanks in advance i have post earlier some problem and get the solution but that was in complete and also i have lost that post url. Problem is, i have following sheet <tbody> Col A Col B S.No. Student Work 1 2 2 3 3 6 4 8 5 4 6 2 7 3 8 6 </tbody> In the above...
  2. V

    Permutation or Combination

    Thanks in advance I want to know that from the given (Query-1) numbers 0,1,2,3,4,5,6,7 (Query-2) numbers 1,2,3,4,5,6,7,8 how many combination we can generate without repetition and if possible pls provide the generated combination.
  3. V

    changes in vb code

    Hi all, i am using this code but want to few changes, please help Private Sub CommandButton1_Click() a = Worksheets(“Sheet1”) .Cells(Rows.Count, 1) .End(x1Up) .Row For I = 2 To a If Worksheets (“Sheet1”) .Cells(I, 3) .Value = “North” Then Worksheets (“Sheet1”) .Rows(i) .Copy...
  4. V

    VB Code or Formula

    pls provide code or formula for a sheet link is https://drive.google.com/file/d/1PS_zvcTpLhqOpa6uclRsh0O-IS0Hvveg/view?usp=sharing you can check the file so that all the points will be clear we need two results 1. After how many rows the digit comes 2. Highlight the cell when the value comes...
  5. T

    VB debug help!

    Hi all, I've got the below code running in my dashboard tab: Sub chart_visibility() ActiveWorkbook.Sheets("Dashboard").Activate If Range("A1").Value = "1" Then ActiveSheet.ChartObjects("Chart 3").Visible = False ActiveSheet.ChartObjects("Chart 1").Visible = False...
  6. J

    VBA to change background color of cell. color based on day of the month

    I have current code to change the background of the cell I updated "Today" to the color of the day. Today is the 15th of the month, so todays color is 15. What I am looking for is the "15" to change based on the day, so tomorrow the code would change to 16 without me going into the code daily...
  7. Johnny Thunder

    VB Code gets different results with different users? - Anyone seen this before?

    Hi guys, saw something weird today. I wrote code that goes into my network at work and grabs a file from a specified folder for our current month "03 - Mar" and does a copy paste to another report. The issue that I saw today is that if another user runs the file the macro is grabbing the file...
  8. M

    VB code to search according to data in search field.

    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)...
  9. S

    help with existing vb code

    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...
  10. T

    Vacation Time Error VBA Code

    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...
  11. R

    VB help in Combining Data from Multiple workbooks into a single workbook with same headers

    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...
  12. L

    Need macro to search column A Sheet 1 for a similar match (about 6 common characters in the same order in the cell) in Sheet 2 then cut column B,C,D,E

    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...
  13. J

    Tewak in the VB code required to perform conditional tasks

    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...
  14. G

    VBA Copy/Paste Worksheet Loop Object Error

    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...
  15. S

    need to edit and add vb code to excel sheet

    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...
  16. M

    VB Code To Move Entire Row Based On Cell Contents

    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...
  17. J

    Searching and unhiding specific worksheets using VB

    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...
  18. B

    Losing VBA when emailing spreadsheet

    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.
  19. P

    Can rows/ columns containing merged cells be transfered to another worksheet through VB codes or other means.

    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...
  20. M

    VB Code issue

    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()...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top