excel routine that can detect when a value is dropped into a cell?

Gobshite

New Member
Joined
Feb 8, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
As part of my job role I have to copy 64732816473218 billion bits of information per second from a web page into excel cell
This was working fine whilst I was dragging from Google Chrome, but know I have to use Internet Explorer it takes 2 hours to paste allllllllll the properties of one word of text on a web page into an excel cell
Rudimentary maths will show the impact on my job has changed what I used to complete in hours, now takes days.

I'm trying to embed some code to so that when I drop text into a cell it only pastes the value, but I fell at the first fence because I cant find an excel routine that can detect when a value is dropped into a cell

Any ideas?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

hicksi

Board Regular
Joined
Mar 5, 2012
Messages
176
As part of my job role I have to copy 64732816473218 billion bits of information per second from a web page into excel cell
This was working fine whilst I was dragging from Google Chrome, but know I have to use Internet Explorer it takes 2 hours to paste allllllllll the properties of one word of text on a web page into an excel cell
Rudimentary maths will show the impact on my job has changed what I used to complete in hours, now takes days.

I'm trying to embed some code to so that when I drop text into a cell it only pastes the value, but I fell at the first fence because I cant find an excel routine that can detect when a value is dropped into a cell

Any ideas?
Rudimentary maths tells me that you shouldn't try to download the Internet...
64732816473218 billion bits???
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,883
Office Version
  1. 365
Platform
  1. Windows
when a value is dropped into a cell
Do you mean, when a cell's value changes?
If so, use the sheet's "Worksheet_Change" event, in the sheet's module, in the VBA project browser.
 

Gobshite

New Member
Joined
Feb 8, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Do you mean, when a cell's value changes?
If so, use the sheet's "Worksheet_Change" event, in the sheet's module, in the VBA project browser.
Pretty sure this does not fire until after the cell as been updated which after the 2 hours it takes to paste all properties. Any other ideas? I think it's beyond the scope of XL
 

Gobshite

New Member
Joined
Feb 8, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Is there an XL setting causing it to default to pasting values only?
 

hicksi

Board Regular
Joined
Mar 5, 2012
Messages
176
Is the Copy from Web automated, or do you select manually in IE?
If manually, you can right-click and paste special data. There's equivalents if you have automated using VBA
 

Gobshite

New Member
Joined
Feb 8, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Do you mean, when a cell's value changes?
If so, use the sheet's "Worksheet_Change" event, in the sheet's module, in the VBA project browser.
Doesn't fire until AFTER the cell has changed. Obviously
 

Forum statistics

Threads
1,144,236
Messages
5,723,173
Members
422,479
Latest member
Mr_Confused

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
Top