deselect

  1. K

    Deselect from Multiselect Dropdown / with vbNewLine / for 2 columns

    I am new to vba, and for two columns I am trying to create a multi-select drop down lists using with vbNewLine (rather than being separated by a comma), but now I want to add in the capability to "deselect" items. This is my current code, as I do not know how to add in the "deselect" code part...
  2. G

    Deselect from Multiselect Dropdown (with vbNewLine)

    Hi all, I am trying to understand VBA as I am working on my document. I am getting stuck at the following issue: For two cells (D43 and D56)I want to be able to deselect values from a multi-select dropdown which presents each value below the other. My current code is as following (without...
  3. D

    Deselect value in inputbox

    Hi, Is there a way of deselecting the value that is in my input box when it opens? If so I'd like the prompt to be after the value. Any help would be appreciated. Thanks Dan
  4. S

    Linking Multiple Check Boxes Together

    Hi All I have a Office 365 spreadsheet with 23 check boxes for categories for sweets (the check boxes either hide or show a row in another sheet). I also want to add a couple of check Boxes that will select all the "chocolate" (checkbox 24) sweets and deselect the remainder or select all the...
  5. D

    Adjusting height of an active x control text box

    Is it possible to increase the height of a active x control text box as you type in it. This would mean that it appears to expand downwards. I tried the auto size feature but this just shrunk the text to squeeze it all in when you deselect the text box.Is it possible to make it just stay...
  6. O

    VBA Code to Deselect a Field

    Thanks in advance for any suggestions for which I will give feedback. Why is the following code not executing? I would like to deselect "Test" which exists in the Pivot Table. Sub Macro7() Dim ShtNameOld As String ShtNameOld = "Test"...
  7. gmooney

    ChartSheet Deselect VBA

    I would like a way via this VBA code to deselect the ChartSheet (Segment & Brand) WITHOUT using the SendKeys command. Private Sub SB() Application.ScreenUpdating = True Sheets("Segment & Brand").Select Application.ScreenUpdating = True End Sub Any thoughts?
  8. A

    VB Code "Pivot Table4" Clear All Filter then "Deselect Blank and "" Values"

    Dear Sir Can someone help for following code; VB Code "Pivot Table4" Clear All Filter then "Deselect Blank and "" Values"
  9. K

    Ctrl to deselect cells not working

    I usually select a line of data, for example (B2 through F2) by holding Ctrl and dragging across the row. and then hold Ctrl and click on B4 to deselect it and copy and paste it onto another sheet. It used to work like a dream. Now it is not working. I only use it on a single row. No merged...
  10. L

    de-select the whole sheet

    Hi I can select the hole sheet by clicking on the icon on top left corner. How can I deselect a sheet with out clicking on any cell? the reason I want to know because I am recording macro that will select and delete the whole sheet then deselect. Thank you
  11. Johnny Thunder

    VBA Question - Deselect after Paste - Excel 2010

    Hi guys, Stuck on a problem with my code, I am creating a new sheet and then doing a copy paste function to get the data onto my newly created workbook/Sheet but for some reasons I can't deselect the pasted cells. Maybe someone can see a problem or a solution for my issue. My code: With...
  12. C

    VBA Code: Deselect Value on Table Depending on Cell Contents

    Firstly Hi. My first post so hopefully its not me being a numpty. I have some data in a table that depending on the value contained in a certain cell i want it to deselect the value in the cell so the rest off the macro can just delete the table contents that do not meet the requirements...
  13. K

    How to deselect the first cell out of column range selection?

    Let's imagine that after filtering, I have the visible cells of L104 to L110. I select that range by selecting the respective Table Header name. Within that range, how to dynamically, deselect the very first cell (L104) while keeping the other (L105 to L110) selected?
  14. C

    Pivot table sorting

    I want to sort by a specific pivot table column, ultimately to copy and past the copied column into a new worksheet. This needs to happen for memo line A B and C. The column is called "Memo" and contains memo line A,B,C and N/A. Problem: I want to deselect all pivot table items then make the...
  15. G

    How to save a function string

    Hey there! First time posting here, so I apologize if anything is amiss! :) Program - Excel 2016 MAC I just moved to excel from Apple Numbers and most of what I am seeing I am liking. However, there are a couple things I have noticed so far that I expected I would be able to do no problem...
  16. T

    VBA for deselecting filter selection

    Hello, I need a VBA that opens the filter dropdown in a column, deselects ",". Thank you, Tony
  17. M

    Deselect range after autofilter

    This seems incredibly simple and straight forward, but no matter how much testing and searching I do I am unable to resolve. I currently have scripting that turns on AutoFilter without selecting anything, but I thought I could copy the data and paste into a new worksheet without the data being...
  18. S

    Changes to cell selection

    Hi, So I had this infuriating problem where I was selecting a lot of cells (using CTRL+Click) and quite a way in to the exercise I made a mistake and tried to deselect (CTRL+Click) and found that the behaviour has been changed. If you CTRL+Click now then it just makes the cell get darker and...
  19. S

    Deselection in data filter

    Hi, I would like to run a macro in which it deselects particular data from whole of the available data. (Just for explanation, its sort of negative approach to data where you don't select certain criteria but deselect some.) Also for the data to be deselected, it would be very useful if it...
  20. R

    VBA to deselect a chart when chart is the only thing on worksheet

    Hi All, Can somebody please help me. I have a worksheet with around 20 small charts which is used as a dashboard for my project. What I would like to do is use this in presentations and have the functionality where if I select a chart, a macro takes me to another tab that contains only that...

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