select

  1. H

    How to select correct range from the cells with formulas

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

    Select a sheet by double-clicking

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

    Invalid Data in Validation Cells

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

    Adding Data to diffrent worksheets from userform

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

    Moving Word to Excel

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

    Toggle Buttons to select multiple sheets for printing

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

    Loop - copy & paste

    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)
  8. D

    excel/word select all then delselect certain items

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

    Problem with VBA

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

    Button Selection

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

    Access Query

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

    Multiple column transpose query

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

    If Value X is selected Rows 1 / 2 will be hidden (+DYNAMIC with previous code)

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

    select the most recent value from one block of 10 columns

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

    VBA Prevent user from entering data into cell

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

    Ugh, this is too tough for me to figure out!!

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

    Internet Explorer Drop Down Box

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

    VBA: Intersect/Match Row and Column to Select Cell

    <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...
  19. kelly mort

    generate 4 - digits pin of same characters or digits

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

    VBA Arrays

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top