select

Im trying to fing efficient and correct logic to select available data on the worksheet(range), which is based on another set of data. Since Im unable to explain the logic required, im attaching the file which features 2 worksheets with 2 colors. 1st worksheet is base and 2nd worksheet is the...

Hello, I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet. I tried with the code below (ThisWorkbook module) but it does not work :cool: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...

I have created a product order form on Excel. In cell A1 I can select a product from a validation list. in cell A2 I can select from a choice of upholstery for that specific product from another validation list. in cell A3 I can select from a choice of weights for that specific product from a...

I have a simple userform setup. i have written code to work on all the userform but what im havint trouble getting to work is: i have 8 diffrent worksheets that i can select what worksheet i place data into. My problem is i cant get the data to go into the first empty cell (Like A1) on the sheet...

Hi All I am hoping somebody can give me some help. I have been working on a word document which I am going to transfer into anExcel spreadsheet. In the organisation that I work, there are a number of services that useoutside Networks for accessing data. More than one service can use the same...

Hi All. I created a user form with multiple toggle buttons. Each buttons represents a sheet in the spread sheet. I would like to be able to only print the pages of the buttons that the user selected. At first I tried to use the respective click button subs to select the sheets. It only select...

Hi, Thanks in advance, I am copying the formula from Range ("A12:A24") And after select the next range ("B12") and paste it Again select the next range ("C12") and paste it Again select the next range ("D12") and paste it How can i do it through loop or vba (Coloumn B to AY)

i know in windows explorer...ctrl + A then holding ctrl then clicking the item you wanna deselect works,....doesn't seem to work for me in excel/word in word, for example, im trying to select all, then deslect the first two headers, then delete the body of text below

Hi there I'm having an issue with a VBA macro- the first half works, however the second 'rule' isn't (in bold type below). I've scoured the forums but can't find an answer. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C23")) Is Nothing Then Exit Sub...

Hi all. I have a user form with two buttons for a selection by the user. It is either the one or the other. You can not select both. If you select Mobile then the word "Mobile" is to be in cell M1. If you select In Shop then the text "In Shop" is to appear in cell M1. If no button is selected...

I am wanting to return all records in an Access table that meet a query criteria. The query I have built via VBA code is - SELECT ID, Price, QtyOut, ValueOut, InStock, ValueInStock, Allocated FROM GoodsIn WHERE Item = '9oz Squat Plastic Cup' AND DateIn <# 22/08/2019# AND Allocated = False ORDER...

Hello - I'm trying to transpose multiple columns into two columns in access (second column being the title) access data currently looks like this Period01 Period02 Period03 120 200 500 110 300 600 200 400 700 I want it to...

Hi All, I am almost in the final stages of my code and I am very excited! So close to the end, I can smell it. Unfortunately this also means he code is getting trickier. What I want to accomplish: I have 2 important dropdowns with each 2 different options: 1. A / B - 2. C / D First...

Hi everybody, I have one block of 10 columns. The 10 columns contain data ordered by year (from the most recent to the oldest - 2019 - 2018 .... - 2010). Example of block of 10 columns: <tbody> company A 2019 A 2018 A 2017 A 2016 A 2015 A 2014 A 2013 A 2012 A 2011 A 2010 value...

I am looking for some help to add too the following code Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim rng As Range Set rng = Range("C11") If Target.Address = rng.Address Then For Each ws In Worksheets Select Case UCase(ws.Name) Case...

Hi, I want to create a drop down where they select a group and all the names fill in below it. GROUP 2 JOHN LARRY LUCY GINA FRANK ANNA Cell A5 is my drop down where they will select the group Starting in A7, I'd like a formula that would look at A5 and start to list the names. Essentially...

I am trying to select from a dropdown in IE from Access VBA. You cannot right click on the dropdown and inspect element. I ended up using something on found online, and it worked for a while, but it has now stopped working. Here is what I was using...

<tbody> Eggs Sausage Toast Bacon Jun 1 Jun 2 Jun 3 x Jun 4 </tbody> Hello, I'm looking for a code to find matching column and row and select that cell. For example, for Sausage and Jun 3, select the 'x' cell. I'm thinking of the cell.find coding but I think that's...

I want a way to generate any of these numbers at a time: 1234 0000 1111 2222 3333 4444 5555 6666 7777 8888 9999 I have this line below here which can check for the availability of those pins . I have been staring at it for a while now hoping to find a way around it but no success yet. I need...

Hello, I am using VBA arrays to select certain options in the list. For Example the Code below Selects five people in the table. What I want to do with the array is to select everything excluding the options already selected. So instead of selecting these five people, select everything else in...