ws.cellsx

Hi all, Below is my coding that helps me search for a word/name in a certain column and return data that relates to this word/name. The values are returned in a neat userform. The only issue I have is that the text I search for may not be unique. There may be 2 or 3 other instances of this...

I have this code that does indeed work, but it is transposing the data. I have tried to change the x and y coordinates but still no luck. Does anyone know how to change this to where the code copy vertically instead of horizontally? Sub getDataFromWbs() Dim wb As Workbook, ws As Worksheet...

Hello, I have this userform: this is the sheet where the code works as I press one of the cells in the range. A2:A27 The code I have on that "Jan" sheet with the cells range for it to work. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Application.Intersect(Target...

Hi All, very new to VB. I want to be able to edit data from list box. I can get the data to transfer the list box into the text boxes. I then want to be able to edit the text box and move it back into excel. I have stumbling through the below code, but it does not seem to do anything. Any...

Hi guys, I have a userform where I can select the worksheets I want to print as pdf. I have saved the names in an array (SheetsToPrint). However, when I get to the line ThisWorkbook.Sheets(Array(SheetsToPrint)).Select, I get run time error 9. Please help. Thank you in advance.:biggrin...

Hello everyone :) I would like some help on a project that i am working on using excel listbox userforms. The point of the userform is to edit/update the data on the master sheet. As you can you see below just by clicking on any of the rows the data will show in the text box and combo box...