oldval

  1. H

    VBA doesn't work for multiple data validation entries

    Hi all. Got this VBA which is supposed to enable the adding and removing of more than one name from within the same cell. It's supposed to behave that if you click the first name it puts it in, if you then click a second different name, it puts that in too, if you come back next week and select...
  2. T

    VB debug help!

    Hi all, I've got the below code running in my dashboard tab: Sub chart_visibility() ActiveWorkbook.Sheets("Dashboard").Activate If Range("A1").Value = "1" Then ActiveSheet.ChartObjects("Chart 3").Visible = False ActiveSheet.ChartObjects("Chart 1").Visible = False...
    • Thoron6
    • Thread
    • activesheet.shapestextbox false oldval true vb code
    • Replies: 7
    • Forum: Excel Questions
  3. J

    Merge Cell range in first empty row

    I'm currently using this code to populate Cell B of the first empty row of Sheet1. Public Sub PO_Notes() Static oldval If Range("J1").Value <> oldval Then oldval = Range("J1").Value a = Worksheets("Temp").Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To a If Worksheets("Temp").Cells(i...
    • js_odom
    • Thread
    • cell end false oldval worksheetssheet1.activate
    • Replies: 1
    • Forum: Excel Questions
  4. J

    VBA enter text in cell if value exists on another sheet

    I am using this code to find if the value in J1 of sheet1 exists in column B of sheet2, Then copy and paste the rows starting in the first empty row of sheet1. I'm sure it could be much cleaner, but it works well. Private Sub Worksheet_Calculate() Static oldval If Range("J1").Value <> oldval...
  5. P

    VBA - Select multiple columns

    Hi all...please help! I'm new to the wonderful world of VBA :) I have a spreadsheet with many pick lists. Some of these should only allow a single item to be selected, some should permit multiples. I have the code to allow multiples to be selected, and have got it working so that it selects a...

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