vba & excel & forms

The code below has this code saying = Nothing? Set PLDataRange = PL.Range("A13:P" & LastRow)?? Private Sub Up_Date_Prices_Click() Application.ScreenUpdating = False Dim SrcOpen As Workbook Dim Des As Workbook Dim JCM As Worksheet Dim PL As Worksheet...

I have a userform and 2 sheets - sheet2 and sheet6. While entering a quantity in number through userform, data stored on sheet 2 is same as entered. Simultaneously the data is then copied to sheet 6 as current stock. However the sheet 6 shows rounded off number eg. if my input value is...

I am developing a program to update issuance of materials for a process. I have made a user form (userform38) with 15 rows to transfer data to a sheet. Each row has 7 textboxes and a command button. Each line has a separate command button to transfer the data to the same sheet. For row one -...

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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