If (Excel Cell = Today the Userform.Textbox = Excel Cell Range)

Guard913

Board Regular
Joined
Apr 10, 2016
Messages
144
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
I am intending on building a Userform that will pull this data into it, but I only want it to pull data that has todays date in it, and then I will have a button next to each row to clear that particular range on excel sheet, and then I want a Final Button that removes all blank ranges and brings data back to top of list in excel. (Unless there is a way to do it all in the button that clears that particular row) I will only have 10 Rows in the Userform to pull into, so code should only pull the first 10 items with todays date. If there are more than 10 items, the I would just push pull set until it says no more items to pull, or remains blank.

It would pull CRN/Task/Date/Email into 4 separate boxes.

If we could get this to work, I can then get 4 other lists configured myself.
 

Attachments

  • Sendpayment.png
    Sendpayment.png
    11.9 KB · Views: 5

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,214,994
Messages
6,122,633
Members
449,092
Latest member
bsb1122

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