Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-07-2019, 03:31 AM
jaffa20 jaffa20 is offline Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another Windows 10 Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another Office 2019
Novice
Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another
 
Join Date: Aug 2019
Posts: 4
jaffa20 is on a distinguished road
Default I tried to record a macro for each checkbox but it reverts to the original selection

I tried recording a macro and getting it to copy the contents of a cell (the dropdown of the customer name) and then do a ctrl + F to find the row of that customer to fill in the cell. However, when I run the macro it just reverts back to the customer which I recorded the macro on. When I view the code to edit it, it specifies the customer. How should I write it so it copies the cell contents and doesn't revert to the original dropdown selection?
Here is the code if it helps:
Code:
Sub AM_Missing_tick()
'
' AM_Missing_tick Macro
'

'
Range("A1:E1").Select
ActiveCell.FormulaR1C1 = "2gether NHS Foundation Trust"
Range("G1").Select
Sheets("Recorded Errors").Select
Cells.Find(What:="2gether NHS Foundation Trust", After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Range("B4").Select
ActiveCell.FormulaR1C1 = "x"
Sheets("Quality Check").Select
End Sub
Reply With Quote
 

Tags
checkbox, excel 2016, vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Specific text fields in PP to specific cells in an Excel table GWRW1964 PowerPoint 0 02-26-2018 07:37 AM
Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another Export Word Drop-Down Content Control to Excel Specific Sheet nolanthomas32 Word VBA 4 09-19-2017 06:25 AM
extract specific pivot table data to a new sheet theexpat Excel Programming 0 02-18-2016 10:08 AM
Excel copy two numbers between specific column and paste in next sheet visha_1984 Excel 1 12-26-2014 07:59 PM
Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another Browse to a specific sheet in an excel workbook Sinister Excel 4 04-08-2014 05:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft