selection criteria

  1. T

    Inserting Dates based on Cell changes and Selection criteria of Status

    Hello Experts, Seeking out for a code : Criteria : 1) When program name is type ( as long as it is a text) automated date with time should be inserted in column "Date Received". 2) On status there is few items in format of drop down list. Every time a particular status is selected then...
  2. G

    Macro code to build to pull from a range of information

    I am very new to writing macros and I have been tasked with the job of taking a worksheet of different phrases and definitions and having them appear in a self created selection window pane when a certain name is clicked. It is confusing to write out but I will show an example below. Ex. I need...
  3. O

    Copying Rows to new sheet based on value

    Hi all, I'm trying use a macro to copy certain rows (with all formating) from one sheet to another based on the contents of column K - "Cmp" in the below extract of "Datasheet1": <TABLE style="WIDTH: 604pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=805...
  4. S

    combo box selection deletes an image

    I have a combo box that has 3 items. It defaults to the primary value (B2). In conjunction to the primary value, I have an image in my spreadsheet that blocks out other cells. I want to setup a macro with this combobox_change that if either of the other two in the list are selected the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top