.offsetrowcount

The following code works great in posting data from one workbook to another but it posts to the last open row. Which was fine at the time but now I want it to do something different. The 1st column in the closed workbook (QuoteListing.xlsx) has unique data in it already and I want to find the...

Good day Everyone Hope the week is treating everyone well so far. I have a VBA code for a user form that is running extremely slow. The code is as follows: Private Sub cmdaddentry_Click() Dim Rowcount As Long Dim ctl As Control If Me.txtshift.Value = "" Then MsgBox "Please enter...

Good evening! I've been battling all day with a piece of code that I'm using to try and create a fool proof system for our engineers to use, but I've hit a stumbling block. I have a userform, that when the UIN is input, it populates the existing fields from the spreadsheet to allow them to be...

Hi everybody! I am trying to pass some data and an image from a userform to another sheet. Everything seems to work fine, all data go in the right place in the other sheet, but instead of the picture, I get a number in the cell! What am I doing wrong? Here is the part of code concerned...

Hi Everyone! I have a workbook i created as an order management system at work. The user form passes data to the sheet. Each PO # has it's own row. I also save a PDF copy of each PO to a folder on my PC. This is a section of my "submit" button code "txtSSPO" is the text box where the PO # is...

Hey all, Thought I'd give you folks a good laugh, perhaps even a hard cry by taking a look at the "Submit" button i have in my ever growing user form for an Order Follow up system. This is a multitude of other's work stitched and sewn together over the years. Everything is working, and it's not...

Below is the code for a userform that im working on. But have str1 & str2 combining but if the user does not select str1 which is a list box it comes up a error. any way around this? Private Sub CommandButton1_Click() Dim RowCount As Long Dim ctl As Control Dim str1 As String Dim str2 As String...

Hi guys, I have created a userform that sends its content to the active workbook (lets call it workbook A) then sends it to another workbook (Workbook B. What I want to do is to add a hyperlink in Workbook B that refers to Workbook A so that the readers easily can trace their way back. My code...