vba & excel & forms

  1. jaeremata

    Print preview multiple sheet into one Print Job (VBA)

    have a check box that has 4 sheets. It's working if I select 1 sheet and it's doing it's job. But I'm having issue when 2 checkbox is selected. It open separate print job. What I want to happen is when when 2 sheets(or more) are selected on the checkbox, it will do a print preview but on one...
  2. M

    VBA Knowledge Required - Automated Sheets Populated Into Templates

    Hi All, I am learning how excel more and more as my job requires me to and try to use it in my personal life where possible. I have created a budgeting workbook and would like to be able to click a button that will extract all the data in the "master calculator (null)" sheet and place it into...
  3. C

    Userform Scrollbar VBA Excel

    Hello, Every time I data is entered I would have to scroll all the way down to see the results in a userform. Is there a way that every time the value is saved to have the scrollbars go all the way down automatically? Like to show the last row.
  4. E

    VBA Addme

    Hi I have a VBA that i'm able to select records from the userform and add them to a new worksheet, however I need the data to start of D9 how do I go about changing the code for this to happen Dim addme As Range Dim x As Integer Set addme = Sheet1.Cells(Rows.Count...
  5. C

    Insert data with VBA command button into password protected sheet

    Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...
  6. A

    PLEASE HELP!!! Can Not Get Formulas To Work??

    I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...
  7. B

    Add vba code into each individual sheet in workbook

    Hi VBA Pros, Hoping you can help, I have a workbook that has many worksheets and each sheet when triggered will be emailed automatically to the the person who's name is the name of the worksheet. - This part is working fine. The challenge im struggling with is because the sheet requires data to...
  8. B

    show Userform when Activecell in table Listcolumn range

    I have an excel table that a user works in and inputs data. When the user tabs (Or Clicks) into a particular cell within a Particular Column of that Table I would like for a Userform to Automatically show and if the User Tabs (Or Clicks) away from that column for the Userform to close...
  9. T

    Userform combobox copy selection and paste

    Hi, Below is a pic of the SOR Validation userform for explanation. Code is below that. I am breaking the issue into small parts. I would like help with the following. Lets say, as is the case in this picture, a user has selected Carpenter_Joiner in first dropdown then CABM03 in the second. This...
  10. A

    At a same time refresh all data connections in all open workbooks

    I have multiple workbooks and I want to refresh all data connections in all open workbooks for that I have given try to following vba code <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...
  11. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet Sub EOD() Dim i AsLong For i =4To ThisWorkbook.Worksheets.Count...
  12. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet <code style="margin: 0px; padding: 0px; border: 0px; font-style...
  13. B

    Userform | Evoke Textbox change event when radio button is changed

    I have three radio buttons that the user can select Uppercase Lowercase Propercase When the form initializes the Uppercase radio button is set to true if the user selects one of the radio buttons I want the text already keyed into a textbox to update to the choosen radio button I have...
  14. T

    Runtime Error

    I have an excel file with several macro that work fine on multiple computers. I have a new employee that just started and the macros do not work for him. He gets a runtime error -2147417848 (80010108). The specific macro is for creating a PDF is that matters. Not sure if it a setting in excel or...
  15. F

    userform.Listbox don't show item

    Hi, I use the code below to create listboxs from adodb.recorset. If rs.recordcount are 0 I've nothing problem. If rs.recordcount are >1 I've nothing problem, the listbox show all record from recordset. But if rs.recordcout =1 the listbox don't show nothing. Somebody can help me to understand...
  16. A

    VBA MACRO TO Keep duplicates BASED ON CONDITION (Remove duplicate if the duplicate count of a particular id is greater 12 times

    In a sheet some 6000 rows are there. Id's are repetitive with different dates. I just want that macro will check the no. of repetition of each id and if the repetition is more than 12 times then it should delete the oldest date. (It means 12 times repetition is fine. If an id is repeated 13...
  17. B

    VBA - Archiving data from one sheet to another and back again?

    I have a data base that I need to be able to automatically archive and remove lines when there are a certain amount of out of date dates. My thought process is to run a check that will detect the out of date dates, select the entire line and remove the data to a holding page until the details...
  18. J

    Dependent Comboboxes

    Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...
  19. P

    vba code to get element from label name

    Hi, I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below <select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...
  20. A

    Javascript to VBA

    Hi Everyone, I coded this following in adobe PDF using java script and I would now like to convert it into excel. Could you please help me with trying to convert this following code into VBA? if (event.value == "Distribution") { var cost = Number(this.getField("cost...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top