Computer Support Forum

Deleting the Check mark only inside the check box using VBA in Excel

Question: Deleting the Check mark only inside the check box using VBA in Excel

Hi all

I have been trying to create an Excel macro that deletes only the check mark inside the check box albeit with no success. Is there a way to do this?? I have plenty of check boxes and it is taking me a lot of time to go into each one and delete only the check marks. It would be would be pretty neat to create a macro to delete the check marks in every single check box. If someone out there has figured out how to do it, it would be a great help.

Thanks

Mario

Relevance 100%
Preferred Solution: Deleting the Check mark only inside the check box using VBA in Excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Deleting the Check mark only inside the check box using VBA in Excel

6 more replies
Relevance 99.63%

hi all,

Can neone help me with this....
When i click the mouse on a cel of the excel sheet, it must be checked ('X' must appear in tht particular cel).
I think this is something to do with mouse click events, i am not sure abt it though.
so if it is to be done with mouse events, how do u go abt it???


help will be appreciated,

thanx
saru.
 

Answer:To check mark a cel in excel

to change colour of cells when something else is done you need to use conditional formatting under the format tab, hope this helps, your post is a little vague.
 

6 more replies
Relevance 98.4%

Could someone please tell me how to insert a check mark (tick) in an Excel document (cell).

Answer:How do I insert a check mark in Excel

click here

4 more replies
Relevance 78.31%

I have a question and not sure if I should uncheck the check mark in the box in my RAMdisk on my SSD. Here is below:

[] Allows files on this drive to have contents indexed in addition to file properties.

Right now there is a check in the box and should I uncheck this or leave it alone as is.

I am not sure about this part.

John

Answer:Do I have to leave a check mark in the box in RAMdisk?

Checking it would likely be of no benefit. The contents of a RAMDisk is volatile, meaning it will be lost after a power down. Thus any indexes are likely to be invalid before they are used. A RAMDisk is very fast and can be searched quickly without indexes.

I am not a big believer in the use of a RAMDisk in a modern operating system. A modern OS has a a sophisticated caching system that provides most of the benefits of a RAMDisk with fewer problems. In most cases a RAMDisk is a poor use of memory. There are legitimate uses of a RAMDisk but not many.

1 more replies
Relevance 78.31%

In dialogs (win7_64) checkbox options for some programs are not visible, see here:
http://i.imgur.com/EQPbwm8.jpg
http://i.imgur.com/PdQoM7h.jpg
Sometimes it does not matter so because there is at least a comma. But sometimes it is quite a problem, because the choice is not visible at all (black square). Is there any fix? What does this relate? Maybe with some DLLs that are not compatible with OS, rewrote by some program? I tried to update the graphics driver, without result.
Thanks for any advice
Peter
 

Answer:Check mark doesn't see_what to do

JoeRay12 said:





Maybe you just need to run the System File Checker (sfc /scannow) tool.
See this guide and scroll down to the steps for Windows 7, and do read even further down how to generate a SFC scan TEXT document to your desktop *IF* it shows unrepairable corrupt files:
https://support.microsoft.com/en-gb/kb/929833Click to expand...

yes Joe,
I made it, now is ok
thx
 

1 more replies
Relevance 78.31%

In dialogs (win7_64) checkbox options for some programs are not visible, see here:
http://i.imgur.com/EQPbwm8.jpg
http://i.imgur.com/PdQoM7h.jpg
Sometimes it does not matter so because there is at least a comma. But sometimes it is quite a problem, because the choice is not visible at all (black square). Is there any fix? What does this relate? Maybe with some DLLs that are not compatible with OS, rewrote by some program? I tried to update the graphics driver, without result.
Thanks for any advice
Peter
 

More replies
Relevance 78.31%

i took commandbars check mark off

Answer:i took check mark off command bar now ihave n

... not enough information!.... Posting is provided "AS IS" with no warrantieshttp://img132.imageshack.us/img132/...Grrrr... ...im

2 more replies
Relevance 77.08%

The following trick worked in W98SE to permanently remove the check mark in the "Always use the selected program to open this kind of file".

I messed up tonight and associated a .dsc file(dscrypt) with Adobe Reader.

I couldn't get it to disassociate from AR with the Default Programs, so I found the registry entry and deleted it with a backup, just in case. All is well now but I want to get that check default check mark out before I mess up again sometime.

UNCHECK OPEN WITH

"This tweak permanently unchecks the "Always use this program to open this file type" checkbox on the "Open With" dialog
box, when opening a non-associated file type. Run Regedit and go to:

HKEY_CLASSES_ROOT\Unknown\shell\openas\command

Add %2 to the current "Default" value as shown here:

C:\WINDOWS\Rundll32.exe Shell32.dll,OpenAs_RunDLL %1 %2

Close Regedit and press F5 to refresh the Desktop."

If you have a problem associating a file after this tweak go to this link for important info:

http://forums.techguy.org/showthread.php?t=85508&page=1&pp=15&highlight=change+file (#8 and #14 Response)

I found this same registry key in Vista and added the %2 and restarted but it didn't have any effect on the check mark.

Does anybody have a solution?
 

Answer:Permanently Remove Check Mark In Always Use This Program---

Nobody with an answer?
 

3 more replies
Relevance 77.08%

I have 2 email accounts. They are both Verizon with MSN Premium. One account's email account is fine. In the other, I cannot delete emails, reply, forward or move to a folder. All of those icons are grey scale. The check box next to the email is gone. It's weird! I don't know what to do as I'm afraid anything I do will affect the other account that's fine. The one that's ok is the primary account and the messed up one is an add on account. Please help!
Thank you.
 

Answer:Solved: Cannot delete emails, check mark box gone

It may help if you tell us with which email client or browser you are accessing the email accounts.
 

3 more replies
Relevance 77.08%

...299. i bet no one got better than this. lmfaorotf. ok this proves my dell really really really sucks, the lowest framerate was 0FPS as in 1 frame every 2 seconds and the highest FPS was only 3. Please i want you to laugh at me.

i know this will wither get deleted or moved but this is the section of the forums with the most people and i want you to tell me how much my computer sucks.

Answer:Check out my amazing 3D mark 2005 score of...

lol


my old emachine was 500ish

5 more replies
Relevance 77.08%

I just found something else. Does anyone know why I have a red checkmark on the folder in folder options? That may get me out of the situation I am in.
Thank you
kali
 

Answer:Solved: Red check mark on folder options

A folder with a red check mark is the standard icon for XPs Folder Options.
 

2 more replies
Relevance 77.08%

am having a problem w/ the green circle check mark virus. keeps running fake scans and wants money to update software. I downloaded the dds and have it on my desk top, but don't know what to do next? Thanks for your help.

Answer:Green Circle w/ Check mark virus

Post your DDS log please.You may need to download these to a cd, external drive, or usb drive and run it on the infected computer but first try to run it from the infected computer.Please download Rkill from the following link.RkillBefore we begin, you should disable your anti-malware softwares you have installed so they do not interfere RKill running as some anti-malware softwares detect RKill as malicious. This link will help you disable them:Click on This Link to see a list of programs that should be disabled. The list is not all inclusive. If yours is not listed and you don't know how to disable it, please ask. Double-click on Rkill on your desktop to run it. (If you are using Windows Vista, please right-click on it and select Run As Administrator) A black screen will appear and then disappear. Please do not worry, that is normal.If you get a message that rkill is an infection, do not be concerned. This message is just a fake warning given by the malware when it terminates programs that may potentially remove it. If you run into these infections warnings that close Rkill, a trick is to leave the warning on the screen and then run Rkill again. By not closing the warning, this typically will allow you to bypass the malware trying to protect itself so that rkill can terminate the malware . So, please try running Rkill until malware is no longer running. You will then be able to proceed with the rest of the guide.Do not reboot your computer after running rkill as the malware... Read more

2 more replies
Relevance 77.08%

I solved this problem!
Thank you

Answer:How do I turn off these check-mark boxes on icons, ect.

Hello Tylar,

This tutorial can help show you how to.

Select Files using Check Boxes - Vista Forums

Merry Christmas,
Shawn

7 more replies
Relevance 76.26%

My image and music icons now have irritating check mark overlays. Before that they were ">>" overlays.
I hate these as they partially obscure the icons. How can I get rid of this?
I tried to insert an example image, I was told that I was not allowed to post URLs.
Thanks for any suggestions

Answer:Image and music icons now have check mark overlays

Hi, you can post the image URLs without the http/www. I will fix it.

2 more replies
Relevance 76.26%

Hello, Before I go on i just want to say that i am a complete novice when it comes to computers and these sorts of things so please keep that in mind when reading my description. A few days ago i had what i thought was a nasty virus on my computer that was characterised by a a green shield with a white check mark in the task bar which started up a fake antivirus program that wanted me to buy it to get rid of the problem. Also sites like viagra.com and others were popping up randomly. I was not able to open any programs such as malwarebytes or avira antivirus so it was impossible for me to get rid of it. Anyway after reading information on this site i used Rkill to close any background programs and then used malwarebytes and avira to scan my system and luckily they were able to find the problem and get rid of it. After the symptoms went away- e.g. no more green shield as mentioned above etc. and i haven't had any problems. This being said however, the trojan seemed that bad that i thought that i must get a second opion from the people who helped me get rid of the thing (you guys!) so i have followed the instructions and included some information from my system- e.g. the dds logs, malwarebytes logs (that found the infection) and avira anitvirus logs (that found the infection). I wasnt able to obtain the gmer logs becuase my system rebooted when i ran the program (no sure the cause of this). I would really appreciate if you could have a look and let me know ... Read more

Answer:Green shield with white check mark trojan

Hi,Welcome to Bleeping Computer. My name is m0le and I will be helping you with your log.Please subscribe to this topic, if you haven't already. You can subscribe by clicking the Options box to the right of your topic title and selecting Track This Topic.Please avoid installing/uninstalling or updating any programs and attempting any unsupervised fixes or scans. This can make helping you impossible.Please reply to this post so I know you are there.The forum is busy and we need to have replies as soon as possible. If I haven't had a reply after 3 days I will bump the topic and if you do not reply by the following day after that then I will close the topic.Once I receive a reply then I will return with your first instructions.Thanks

15 more replies
Relevance 75.44%

Not sure how to describe this issue. The icons on my desktop have a lock in the lower corner. Indicating that they are not to be shared. This lock randomly switches to a green check mark or to a grey X or sometimes to the file shared icon. Different ones switch to different icons when it happens. So not just the folders or just the shortcuts. But all desktop icons. The main icon picture stays the same, it's the lower corner spot that changes around randomly. The little arrow that indicates that the icon is a shortcut. This even happens on my game icons. Is this a sign of a malfunction or maybe mal-ware? I do not have Mozy or Norton installed. Running Win 7. When I turned on my PC today a AMD update was prompted. Assuming it was for a driver update, I clicked ok. Even though I uninstalled and reinstalled my driver yesterday, to try and fix a flickering problem. The update looked legitimate. Today I also uploaded and downloaded a small video file from "Bloggif.com". While I was trying to create an animated .gif. The animated .gif worked. This seems like one of those things that happens when I don't know that my pinky finger is resting on the ctrl key. But can't figure out how to keyword troubleshoot through Google. Any help or tips would be great and I thank you.
 

Answer:Green Circle with White Check Mark on Desktop Icons

Is this just the icons on your desktop, or do you see the check marks on ALL files/folders? (If you open Explorer....)

The only thing I can think of if you don't have Mozy or Norton, or some other online backup tool, would be encryption. The lock if the file is inaccessible, and the checkmark if it is accessible.
 

2 more replies
Relevance 74.21%

Hi,
Does anyone know if one can remove the green check marks in file explorer that indicate that a file is synced on OneDrive?
If one is using list, details or small icon view, there is no way to visually see the file type.
Thanks, Paul

More replies
Relevance 73.39%

I really need help here!

My problem:

I've been using this hard drive that Windows 10 runs on for about 4 years now and I just want to check if the HDD is healthy.

I'm just VERY worried that this hard drive has physical problems and is about to die.

How can I check if this hard drive has physical problems?

Answer:Please Help: How to check if HDD inside Windows 10 PC is damaged?

The best tool in my opinion to get a comprehensive report on your disk health is Speedfan (now v4.52) direct download from

Download SpeedFan - Access temperature sensor in your computer

main site Download SpeedFan - Access temperature sensor in your computer

Free to download and use, once installed, it runs as a service from the notification area of the taskbar, measuring chip temperatures from various sensors on your system.

Click on the icon there (it may appear as a fan, or a system temperature in blue), and the UI will popup:


Once you have run the S.M.A.R.T. test for your selected hard disk from the tabbed interface, which gives a list of the SMART disk parameters observed, there is a button to perform an in-depth analysis, which gives you a report of the state of your disk in your default browser, in plain English, with recommendations based on the findings:

3 more replies
Relevance 73.39%

I really need help here!

My problem:

I've been using this hard drive that Windows 10 runs on for about 4 years now and I just want to check if the HDD is healthy.

I'm just VERY worried that this hard drive has physical problems and is about to die.

How can I check if this hard drive has physical problems?

Answer:Please Help: How to check if HDD inside Windows 10 PC is damaged?

The best tool in my opinion to get a comprehensive report on your disk health is Speedfan (now v4.52) direct download from

Download SpeedFan - Access temperature sensor in your computer

main site Download SpeedFan - Access temperature sensor in your computer

Free to download and use, once installed, it runs as a service from the notification area of the taskbar, measuring chip temperatures from various sensors on your system.

Click on the icon there (it may appear as a fan, or a system temperature in blue), and the UI will popup:


Once you have run the S.M.A.R.T. test for your selected hard disk from the tabbed interface, which gives a list of the SMART disk parameters observed, there is a button to perform an in-depth analysis, which gives you a report of the state of your disk in your default browser, in plain English, with recommendations based on the findings:

6 more replies
Relevance 73.39%

Logfile of HijackThis v1.99.1
Scan saved at 6:31:09 PM, on 1/6/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\csrss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Windows Defender\MsMpEng.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\CTsvcCDA.EXE
C:\Program Files\Diskeeper Corporation\Diskeeper\DkService.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\wdfmgr.exe
C:\WINDOWS\System32\alg.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Java\jre1.5.0_09\bin\jusched.exe
C:\Program Files\Creative\Sound Blaster X-Fi\DVDAudio\CTDVDDET.EXE
C:\Program Files\Creative\Shared Files\Module Loader\DLLML.exe
C:\Program Files\Creative\Sound Blaster X-Fi\Volume Panel\VolPanel.exe
C:\WINDOWS\CTHELPER.EXE
C:\WINDOWS\system32\CTXFIHLP.EXE
C:\WINDOWS\system32\LVCOMSX.EXE
C:\Program Files\HP\HP Software Update\HPWuSchd2.exe
C:\WINDOWS\system32\RunDLL32.exe
C:\Program Files\Windows Defender\MSASCui.exe
C:\WINDOWS\SYSTEM32\CTXFISPI.EXE
C:\Program Files\Creative\MediaSource\Detector\CTDetect.exe
C:\Windows\xpupdate.exe
C:\Program Files\Creative\ShareDLL\CADI\NotiMan.exe
C:... Read more

Answer:Routine Check-UP, HiJackT Log inside!

You've got some nasties on there....

Hello and Welcome. Please subscribe to this thread to get immediate notification of replies as soon as they are posted. To do this click Thread Tools, then click Subscribe to this Thread. Make sure it is set to Instant Notification, then click Subscribe.

Before begining the fix, read this post completely. If there's anything that you do not understand, kindly ask your questions before proceeding. Ensure that there aren't any opened browsers when you are carrying out the procedures below. Save the following instructions in Notepad as this webpage would not be available when you're carrying out the fix.

It is IMPORTANT that you don't miss a step & perform everything in the correct order/sequence.

---------------------------------------------------------------------------------------------

Download SDFix and save it to your Desktop.

Double click SDFix.exe and it will extract the files to %systemdrive%
(Drive that contains the Windows Directory, typically C:\SDFix)

We'll use this later.

----------------------------------------------------------------------------------------------------------

Please download FixWareout from one of these sites:
http://downloads.subratam.org/Fixwareout.exe
http://www.bleepingcomputer.com/file...Fixwareout.exe

Save it to your desktop.

Windows Defender

Please disable your Windows Defender Real-time Protection, as it may hinder the removal of some entries.Open Windows De... Read more

16 more replies
Relevance 73.39%

My son downloaded Limewire! arg. he hasn't done anything on it yet cause I said I needed it check first so I ran all tests, got rid of junk and created a Hijack This log. Can you please check it to see if there are any problems? Thanks!

Here's my hijack this log:

Logfile of HijackThis v1.98.2
Scan saved at 5:10:07 PM, on 12/5/04
Platform: Windows 98 SE (Win9x 4.10.2222A)
MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106)

Running processes:
C:\WINDOWS\SYSTEM\KERNEL32.DLL
C:\WINDOWS\SYSTEM\MSGSRV32.EXE
C:\WINDOWS\SYSTEM\MPREXE.EXE
C:\WINDOWS\SYSTEM\mmtask.tsk
C:\WINDOWS\SYSTEM\MSTASK.EXE
C:\OFFICE51\SOINTGR.EXE
C:\PROGRAM FILES\GRISOFT\AVG6\AVGSERV9.EXE
C:\WINDOWS\SYSTEM\ZONELABS\VSMON.EXE
C:\WINDOWS\EXPLORER.EXE
C:\WINDOWS\TASKMON.EXE
C:\WINDOWS\SYSTEM\SYSTRAY.EXE
C:\PROGRAM FILES\EASY KEYBOARD\EASYKEY.EXE
C:\WINDOWS\SYSTEM\ATIPTAXX.EXE
C:\PROGRAM FILES\GRISOFT\AVG6\AVGCC32.EXE
C:\PROGRAM FILES\VIEWPOINT\VIEWPOINT MANAGER\VIEWMGR.EXE
C:\PROGRAM FILES\ZONE LABS\ZONEALARM\ZLCLIENT.EXE
C:\PROGRAM FILES\AIM\AIM.EXE
C:\PROGRAM FILES\NETZERO\EXEC.EXE
C:\PROGRAM FILES\LIMEWIRE\LIMEWIRE 4.2.3\LIMEWIRE.EXE
C:\WINDOWS\SYSTEM\WMIEXE.EXE
C:\WINDOWS\SYSTEM\DDHELP.EXE
C:\PROGRAM FILES\COMMON FILES\REAL\UPDATE_OB\REALSCHED.EXE
C:\PROGRAM FILES\NZSEARCH\HCM.EXE
C:\PROGRAM FILES\HIJACKTHIS.EXE

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Bar = http://my.netzero.net/s/search?r=minisearch
R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Page = http://my.n... Read more

Answer:Suspecting Problem-Please Check! HJT log inside

hi welcome to tsg.

have hijack this fix these entries

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Bar = http://my.netzero.net/s/search?r=minisearch
R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Page = http://my.netzero.net/s/search?r=minisearch
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Search_URL = http://my.netzero.net/s/search?r=minisearch
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Search Page = http://my.netzero.net/s/search?r=minisearch
R0 - HKLM\Software\Microsoft\Internet Explorer\Search,SearchAssistant = http://my.netzero.net/s/search?r=minisearch
R1 - HKCU\Software\Microsoft\Internet Explorer\SearchURL,(Default) = http://my.nezero.net/s/search?r=minisearch
R1 - HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings,ProxyOverride = 64.136.29.30;64.136.21.30;64.136.29.34;searchap.untd.com;127.0.0.1;localhos t;*windowsupdate.microsoft.com;*windowsupdate.com;*wustat.windows.com;*.pog o.com;*test-speed.com;*jetblue.com;<local>
R3 - URLSearchHook: URLSearchHook Class - {37D2CDBF-2AF4-44AA-8113-BD0D2DA3C2B8} - C:\PROGRAM FILES\NZSEARCH\SEARCHENH1.DLL
O2 - BHO: X1IEHook Class - {52706EF7-D7A2-49AD-A615-E903858CF284} - C:\PROGRAM FILES\NETZERO\QSACC\X1IEBHO.DLL
O3 - Toolbar: &Radio - {8E718888-423F-11D2-876E-00A0C9082467} - C:\WINDOWS\SYSTEM\MSDXM.OCX
O3 - Toolbar: ZeroBar - {F5735C15-1FB2-41FE-BA12-242757E69DDE} - C:\PROGRAM FILES\NETZERO\TOOLBAR.DLL
O3 - Toolbar: ZeroBar - {F0F8ECBE-D460-4B34-B007-5... Read more

3 more replies
Relevance 72.57%

Logfile of HijackThis v1.97.7
Scan saved at 04:41:12, on 16/11/2004
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Unable to get Internet Explorer version!

Running processes:
D:\WINDOWS\System32\smss.exe
D:\WINDOWS\system32\csrss.exe
D:\WINDOWS\system32\winlogon.exe
D:\WINDOWS\system32\services.exe
D:\WINDOWS\system32\lsass.exe
D:\WINDOWS\system32\svchost.exe
D:\WINDOWS\system32\svchost.exe
D:\WINDOWS\System32\svchost.exe
D:\WINDOWS\System32\svchost.exe
D:\WINDOWS\System32\svchost.exe
D:\WINDOWS\system32\spoolsv.exe
D:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
D:\WINDOWS\system32\crypserv.exe
D:\Program Files\Norton AntiVirus\navapsvc.exe
D:\Program Files\Norton AntiVirus\AdvTools\NPROTECT.EXE
D:\WINDOWS\System32\svchost.exe
D:\Program Files\Common Files\Symantec Shared\Security Center\SymWSC.exe
D:\WINDOWS\Explorer.EXE
D:\WINDOWS\System32\alg.exe
D:\Program Files\Common Files\Symantec Shared\ccApp.exe
D:\WINDOWS\SOUNDMAN.EXE
D:\WINDOWS\System32\svchost.exe
D:\WINDOWS\system32\wuauclt.exe
D:\Documents and Settings\phil crane\Desktop\HijackThis.exe

R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.trafficswarm.com/cgi-bin/swarm.cgi?269446&64956c8bfb9311429349d4d9c9134349
R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Window Title = Phil Crane Internet Explorer
O2 - BHO: NAV Helper - {BDF3E430-B101-42AD-A544-FADC6B084872} - D:\Program Files\Norton AntiVirus\NavShExt.dll
O3 - Toolbar: Norton AntiVirus - {42CDD1BF-3FFB-4238-8AD... Read more

Answer:i have a problem just a quick check hijack log inside

am i safe to say i can remove these
O3 - Toolbar: (no name) - {E0E899AB-F487-11D5-8D29-0050BA6940E3} - (no file)
O16 - DPF: {0E5F0222-96B9-11D3-8997-00104BD12D94} (PCPitstop Utility) - http://www.pcpitstop.com/pcpitstop/PCPitStop.CAB
and any ideas what this could be

O4 - Global Startup: Adobe Gamma Loader.lnk = D:\Program Files\Common Files\Adobe\Calibration\Adobe Gamma Loader.exe
 

1 more replies
Relevance 72.57%

I'm recently noticed that some zip files that I store images on contain some empty image files "0 KB".
I'm just wondering if anybody knows of a quick way to scan a bunch of folders each with several zip each and then show which zip files contain empty files.

Thank you.

Answer:Check inside zip files for empty file

Use wither 7-zip or Winzip. Basic computing 101.

6 more replies
Relevance 72.57%

http://support.dell.com/support/edocs/systems/dkub/specs.htm
The system is a Dell Dimension XPS T500 but I have put into it 3 sticks of 128mb SDRAM (PC100mhz), a Geforce2 MX, with a 500mhz cpu. Just wondering if I could put in a new CPU that would be compatible with the board.

At the moment the cpu is keeping me back from low-level gaming, because this computer is used mainly for Internet,email, and other things not used on my other XP (see specs. in my sig). Thanks guys if you need more info ask.
 

Answer:Could it be possible to upgrade?, an old PIII check inside for specs.

7 more replies
Relevance 71.34%

Trying to get rid of Cid Help popups..... If someone could tell me which files i need to delete it would be great.

Logfile of HijackThis v1.99.1
Scan saved at 9:14:04 AM, on 6/13/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exe
C:\Program Files\Common Files\LightScribe\LSSrvc.exe
c:\progra~1\mcafee\mcafee antispyware\massrv.exe
c:\program files\mcafee.com\agent\mcdetect.exe
c:\PROGRA~1\mcafee.com\vso\mcshield.exe
c:\PROGRA~1\mcafee.com\agent\mctskshd.exe
c:\PROGRA~1\mcafee.com\vso\OasClnt.exe
C:\PROGRA~1\mcafee.com\vso\mcvsshld.exe
c:\program files\mcafee.com\agent\mcagent.exe
c:\progra~1\mcafee.com\vso\mcvsescn.exe
C:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\MDM.EXE
C:\PROGRA~1\McAfee.com\PERSON~1\MpfService.exe
C:\PROGRA~1\McAfee\SPAMKI~1\MSKSrvr.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Syrus\Syrus Application Update\SyrusAppUpdateClient.exe
C:\Program Files\Hewlett-Packard\Shared\hpqwmiex.exe
C:\Program Files\ATI Technologies\ATI Control Panel\atiptaxx.exe
C:\Program Files\hpq\HP Wireless Assistant\HP Wireless Assis... Read more

Answer:Check my hijackthis log please need help deleting Cid Help

Add remove programs - remove logitech desktop messenger - Bear Share, the likely source of your infections

===========
Please Download NoLop to your desktop from

http://www.thespykiller.co.uk/index...be028538366e8b644d0e9fd&action=tpmod;dl=get16

First close any other programs you have running as this will require a reboot
Double click NoLop.exe to run it
Now click the button labelled "Search and Destroy"
<<your computer will now be scanned for infected files>>
When scanning is finished you will be prompted to reboot only if infected, Click OK
Now click the "REBOOT" Button.
A Message should popup from NoLop. If not, double click the program again and it will finish Please Post the contents of C:\NoLop.log along with a fresh HijackThis log

--If you receive an error, "mscomctl.ocx or one of its dependencies are not correctly registered," please download http://www.boletrice.com/downloads/mscomctl.ocx to your system32 folder then rerun the program. -
==================

Download Superantispyware (SAS)

http://www.superantispyware.com/superantispywarefreevspro.html

Install it and double-click the icon on your desktop to run it.
It will ask if you want to update the program definitions, click Yes.
Under Configuration and Preferences, click the Preferences button.
Click the Scanning Control tab.
Under Scanner Options make sure the following are checked:
o Close browsers before scanning
o Scan for track... Read more

3 more replies
Relevance 70.52%

A buddy of mine had a PC that the RAM died on. It's at my house now and I am in the process of reformatting, replacing RAM, etc. (SDRAM)

Anyways, his other computer decided that it too was going to die on him.

Today he went to boot it up. It gave him the Disk Check screen as if the power was turned off incorrectly. He hit 'ok' and continued the check. He realized then that it said "Deleting files on C:\" and then gave a status bar with the files being deleted.

He immediately powered off. When he booted back up, he skipped the check and tried to boot normally. When he tried to log on Windows gave him and error message and code. Something along the lines of "A problem occurred that is preventing Window's from verifying the license information" Error Code: 0X8007007E

Any idea what in the fuck just happened to his PC?
 

Answer:Disk Check deleting files?

I'm taking a wild guess that he had some sort of virus on the second PC.
 

1 more replies
Relevance 69.7%

Actually this happen ages ago but since it done nothing with the hard drive(or it seems do nothing) i didn't worry
Until today I relieze when I want to make fan videos again,I found like 5 videos are missing.I search for them bbut nothing came up
I download the videos again and went I reboot,the computer want to check my HD and I was slow at canceling it..so when it load up,I go to my HD again,and I lost one video again

Can I disable it from checking my second HD or make it shut up on trying to check my HD?

Answer:Windows Disk Check Deleting Files On Second Hd

I'm unsure of what your problem is and what you're asking. In the BIOS there is a section to change the boot device order. There should be an option in there. You're not dual booting with a second OS are you?
Mark

7 more replies
Relevance 67.24%

Hi, I am currently an intern for this small company and I was told to delete the archive in outlook for all the users the problem is that I have to make sure that there is no password set otherwise if I delete it and there was a password and the user can not remember his password I will mess it up, because after deleting it I need to put the archive back and the user may need to enter his password

Answer:Before deleting an archive in outlook for a user how can I check if his outllook account has a password set

Quote:





Originally Posted by fregoton


Hi, I am currently an intern for this small company and I was told to delete the archive in outlook for all the users the problem is that I have to make sure that there is no password set otherwise if I delete it and there was a password and the user can not remember his password I will mess it up, because after deleting it I need to put the archive back and the user may need to enter his password




Well if your not sure wether or not the user has a password setup on their outlook.
You may want to ask them if they have one setup, if so ask them for it.
Jot down whatever they say so you'll have a list when you get to your desk to begin working.
Next you read this guide here https://kb.xavier.edu/page.php?id=35627.
If you can remove their passwords succesfully, then you may delete the archive.
Once your company restores whatever archive they want let the users setup their passwords if the company ask for it.
Otherwise that would be one good way of doing it, even if they aren't in the building.
Call them if its ok with your supervisor and get done what you needed.

1 more replies
Relevance 66.42%

The problem start with my wife's PC. It started a few weeks ago she told me. She can't open Outlook Express (doesn't start), access My Space or get updates at Windows Update. Also some images on sites do not load.

I then checked my PC and found, I couldn't access Windows Update, My Space, Thunderbird fails to retrieve emails. I have not noticed any issues with images.

Given this sounded like some of the behaviors I have heard of trojans doing I thought I would post my logs here and see if anyone sees anything out of place. Normally I wouldn't consider a cross contamination but about two weeks I temporarily set up a home network between our PCs to share a few files. The next day I disabled NetBIOS on my PC but as we are both behind a hardware firewall, I guessing if it happened it must have happened then.

Nothing jumps out at me but I wanted to get a second opinion.

Any help would be appreciated.

Wife's PC
Logfile of HijackThis v1.99.1
Scan saved at 5:12:51 PM, on 4/30/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16414)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\Kaspersky Lab\Kaspersky Anti-Virus 6.0\avp.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\sys... Read more

Answer:Hijack This Check (Can't Update Windows, Check Email or access My Space)

I ran SuperAntiSpyware and found nothing but 10 tracker cookies. Running Panda Virus Scanner online. I couldn't run F-Secure because IE7 Active X controls prevent it from running.

Zero clue as to what is going on so far.
 

3 more replies
Relevance 66.42%
Question: excel check box

I know this issue has been covered before but i cant find anything specific to what i need. Im sure it is very simple. I would like a couple check boxes and when they are checked 1 will add the value of $25 to cell m18 and 1 will add the value of $30 to cell m19. Can someone please give me some code for this.
 

Answer:excel check box

9 more replies
Relevance 66.42%
Question: Excel Check Box

Does anyone know how to create a check box in excel 2007.
I found the instructions for excel 2003 by Googling but its different in 2007. Any office guru out there?
 

Answer:Excel Check Box

Hello there,

You can get a Checkbox by going to the Developer tab and clicking the Insert split menu. You can then create a Forms or a Controls Toolbox control. Depending on what you want to do may change which you create. The Controls Toolbox controls are ActiveX controls, while the Forms controls are legacy controls.

And if you do not have the Developer tab visible, click the Office Button | Excel Options | Popular (on the left) | Show Developer tab in the Ribbon (check) | Ok.

HTH
 

1 more replies
Relevance 66.42%

Hi, i have hp pavilion g6 laptop and its upgraded from windows 8 to 8.1 then windows 10.  From last few days i was getting "Memory_Management", "Kernel_Data_Inpage_Error" and so many other errors with blue screen. Due to this i have to power off the system from main power button by holding for few seconds. Now i was getting hang problem. I saw in task manager that DISK UTILIZATION was 100%. I did a hardware test where i got below results : HARD DRIVE SHORT DST Check : WARNING HARD DRIVE Optimized DST Check  : FAILEDFAILURE ID: 9U3UWX-6KT85B-MFPWWJ-61Q003 Can anybody tell me how to resolve this or i need to replace the hard drive. -ThanksPankaj 

Answer:Hard Drive Short DST Check : WARNING and Optimized DST Check...

Yes you need to replace the hard drive. Since you have upgraded to Windows 10 it is very easy to get recovery media directly from the Microsoft Media Creation Tool. For most people, the problem is not physically swapping out the hard drive, but restoring the operating system since they do not have recovery disks. Post back if you want a service manual and/or video showing the replacement, purchase options for a new hard drive and step-by-step for restoring Windows 10. We would need the full model...g6-???? 

2 more replies
Relevance 66.42%

Is verifying files by check sum / content after transferring (copying, moving) indeed unreliable?

Since "ever" I - if I checked files at all - checked files by content or check sum after transferring them, so this information sounds very astonishing to me now, I hadn't had any clue about what I read here: http://blogs.msdn.com/b/oldnewthing/archive/2012/09/19/10350645.aspx

Obviously meaning in many cases checking files by content / check sum checks the data in the buffer, if I see it right.

So, is it like that? Does it refer to all of the synchronizing / backup / copying, check sum, etc. programs?

And what is the best / easiest way to (automatically) check files after transferring. E.g. when copying all of the files of a 4TB drive to another one.
 

Answer:Verifying files by check sum / content after transferring unreliable - how to check?

Re: Verifying files by check sum / content after transferring unreliable - how to che

Kletus...

I'm not in my league with this, but could this make sense?

I think the article is referring to times when you are seeking to verify data across a network span between two systems (operating systems), where system b (copy destination) requests a checksum from system a (file original location). I believe the author is saying that in that particular situation checksums would be created from the cache/buffer on both computers. In the case of you copying to a secondary disk connected to a single computer I think the checksum should work fine. Sounds like one of those programmer's dilemmas to me.

Sorry if I am off on this. I know you are looking for some programming expertise. I'll just say that reading this, it made sense to me about the author's comments:



This really sounds like you're overthinking it.

First, what possible reason would there be for giving someone write access but not read access to a certain location? That's screwed up on so many different levels...

Second, you're right that having the sender compute a checksum of the destination file is a bad idea for all the reasons mentioned. But why did you even think of doing that in the first place?!? If I was implementing a system like that, I'd have the *destination* system compute the checksum on the file it received and send it back to the sender for verificati... Read more

5 more replies
Relevance 66.42%
Answer:how do i change ms word's spell check to check for british spelling?

is there a british version of office xp? i dont know if you can do that


 

6 more replies
Relevance 66.42%

Hello, My PC is disk usgae is at 100%  and somtimes the CPU usage jumps up to. I tested my system and recived- Hard Drive Short DST Check and Long DST Check: Warning  How do I determine what the warning is? Do this mean my hard drive is on the verge of failing? 

More replies
Relevance 65.6%

I have a column in an Excel spreadsheet that I would like to be able to put a "check" in when I receive an order. Is it possible to put a check box in a column?
 

Answer:Excel: Is it possible to put a check box in a column?

7 more replies
Relevance 65.6%

I need help with this Macro.

I have a checkbox that I created from the Control Tool Box. This box is named CheckBox1. I then right clicked the box and clicked on view code. I now have created a private sub macro called CheckBox1_Click with the following code. This code is in the TARION Freehold Enrollment worksheet

Private Sub CheckBox1_Click()

Sheets("TARION Freehold Enrollment").Select
If Sheets("Information").Range("O5") = "Detached" Then

CheckBox1.Value = True
Else
CheckBox1.Value = False
End If

End Sub

This macro works fine when I test it using F8

I then created another private sub in the Information work sheet as follows:

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("O5") = "Detached" Then

Application.Run "CheckBox1_Click"

End If

End Sub
I want this second macro to run the first macro.

Now cell O5 is a dropdown list. What I want the second macro to is this. When I change the dropdown list to say "Single" then I want the second macro to automatically run the first macro and delete the check mark if it is there. If the dropdown list reads "Detached" then I want the box to be checked. But I get an error on the second macro on the line that reads Application.Run "CheckBox1_Click"
What am I doing wrong??

Mario
 

Answer:Solved: Check Box in Excel

9 more replies
Relevance 65.6%

I just learned how to create a check box so any help would be appreciated.

What I would like to do is change the output in the Linkedcell when the box is checked or not.

When you check the box the output in the LinkedCell is "TRUE" and "FALSE" when not checked. How/where can I change what the output is, for example I would like the linked box to say "West File" when checked. Also if I have multiple Check Boxes linked to the same cell how do I make the ouput blank for "false" (not checked).

I know how to do this in a round about way:Set my desired cell to read =IF(F106=TRUE,"West File","") Where F106 is a random cell that the check box is linked to, but that doesnt work for multiple check boxes (with only one possibly being checked) outputing onto one cell and it would be nice to eliminate the intermediate cell and just have the check box output value be custum.

Thanks

Thanks
 

More replies
Relevance 65.6%

I have what I believe is a probably Hard Disk failiure; however, the Windows utility provides different output than the error codes provided by the System level check. The below is from my OS check:Microsoft Windows [Version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C:\Users\user>wmicwmic:root\cli>diskdrive get statusStatusOKwmic:root\cli> It seems to indicate status as OK. However, the system level Hardware Test before booting shows the following:Failiure ID is: 9PMPKK-5B284T-XD002K-60QS03Product ID is XG809UA#ABA  I assume the OS level SMART Test is less reliable, then?Thanks!

More replies
Relevance 65.6%

i have a panasonic toughbook cf 53 running windows 7 pro.my computer works fine. when i turn the computer on it states that there is a media test failure check cables. the only thing that is not working on my computer is the sound. i have checked the control panel and the settings, nothing is muted. im confused why the sound will not turn on. i pressed fn f4 to mute the volume and now it seems to be stuck on mute? any help would be greatly appreciated.thanks, jason

Answer:media test failure check check cables.

Check in Device Manager. Are there any yellow exclamation points?You've been helped by a 14 year old.

6 more replies
Relevance 65.6%

My daughter called me and asked what was wrong with her monitor. She said that when she starts her computer she gets this message "Self check, check your PC and signal cable, monitor is working" and no other display...

kds x-flat monitor, onboard video, XP, AMD

She has unplugged and replugged the video cable several times... any ideas why this is?
 

Answer:Self check, check your PC and signal cable, monitor is working

That suggests that the computer is not booting, or if it is, there is no video output.

The monitor is simply saying "I am OK, but the computer isn't sending me anything"

A simple check to see if the computer is booting is to try the CAPS Lock key. Pressing it will toggle the CAP light on and off each press, if the PC is running.
 

2 more replies
Relevance 65.19%

How can I script this to a command button? When the button is clicked, it removes the checkmarks from each checkbox in the Excel 2000 worksheet.

Thanks,

Drew
 

Answer:Excel: Remove Check from Checkbox

14 more replies
Relevance 65.19%

Does anyone know of any way to add a check box to a cell in Excel 2002?

I need to be able to click on a box (or use the spacebar if using the keyboard) to add a check and then be able to sort the entries according to whether or not there is a check mark in the box.

We do not have Access, and I am trying to achieve this task without having to invest in Access. I currently have a column that I add an "X" to and sort that way, but I am looking for something easier.

It also needs to be compatible to Excel 2000, as some of our workstations still have that.

NOTE: If anyone can confirm absolutely that this can not be done, I would appreciate that as well.
Many many thanks!

-tim
 

Answer:Add a check box to an Excel 2002 cell?

It can certainly be done, Tim. But it's a lot more work.

You need to View-Toolbars, Control toolbox.

Use the checkmark from there.

Then you have to assign values to them and, I believe, you'll have to store those into a column anyway (maybe hide that column), and then sort that hidden column. Just like you're doing with the X's now.

Also, it'll require some VBA programming. I can't help with that part, but I'm sure someone will.
 

2 more replies
Relevance 65.19%

HI,
When using Excel 97 (work/NT machine) receive a Dr Watson error when selecting the "spell check" function?

Can anyone help/advise?

Is creating a new *.dic file worth it?
 

Answer:Excel 97 Error when using Spell Check?

>> receive a Dr Watson error ...
>> Can anyone help/advise?

Can you tell us what the message is?

Rgds,
Andy
 

2 more replies
Relevance 65.19%

I did a spell check in excel but it did not pick up 'f' as an incorrect word (should have been 'of'). On investigation it also accepted 't' and 'g'. How can I remove 'f' etc from the main dictionary so that it shows up as an incorrect word.

Answer:how do I check the word bank in excel

I have now found a solution. The dictionary to alter is the exclude dictionary. I found this information on the following site:http://wordfaqs.mvps.org/ExcludeWor...It works.

15 more replies
Relevance 65.19%

Hi
Using excel 2003, I'm trying to have cell d13 equal d12 if the check box4 is checked in cell a13.

Any ideas would be appreciated.

I tried this without success. I believe I'm mixing up different programs

Sub Checkbox()
If CheckBox4.Value = True Then
Range("C13").Select
Selection.Copy
Range("D13").Select
ActiveSheet.Paste
Else
Range("d13").Value = ""
End If
End Sub
 

Answer:Solved: Excel 2003 Check box help

6 more replies
Relevance 65.19%

Hi,

I am trying to genterate a column of check boxes in excel. The way I want it to look would be column A would just be check boxes, going all the way down, based on the number of rows that I am generating. Then columns B - ?? will have data in it. Then when a user clicks on the selected check boxes, i want to have a command box to get rid of the rows without the "checked" check boxes. The part that I need help with is generating the column of check boxes "A". I have all the data coming from a different spread sheet and columns "B - ??" are working fine. If anyone can help, it would be great! Thanks
 

More replies
Relevance 65.19%

I have spell checking working in Word .. why oh why won't it work in Excel please?

Answer:Spell-check in Excel - it don't work!

What Happens? Error message? Version of Excel?

4 more replies
Relevance 65.19%

firstly i know nothing about programming and have only just started with excel. I am tasked with having a list of 75 keywords where some include @ or . as well as words such as [email protected], news, facebooki have to filter this list against an 80k list and where any of these keywords exist i have to delete the whole line.I have tried so many times to do the advanced filter and it just wont work. is there not a plug in or easier way as two at a time filter is taking forever.from desperate penny message edited by pennypedley

More replies
Relevance 65.19%

This is a followup to my "Data transfer between 2 different open Apps" thread, which is now functioning...sort of. I have not found a way to access the data from the workbook which is opened in the second application. I can only reopen it from it's last saved location, which is OK, if I know that the workbook has not been changed since it was last saved. Part of what I'm doing uses a IsFileAlreadyOpen function (kernal32) as recomended to me in that thread.

QUESTION: I would like to know if an open workbook has been changed since it was last saved. This workbook is in a different app. Is there a function (perhaps kernal32) that can be called to give me the changed state of a workbook?
Thanks,
Tom
 

Answer:VBA Excel: Check if a workbook has been changed

7 more replies
Relevance 65.19%

Hi,I have 3 sheets in Excel that each contain data for a person's name and their corresponding personal number. I would like to cross check the sheets and add any names/#'s appearing on all 3 sheets to a 4th sheet. Can someone help me find the best way to do this? It would be reaaally helpful!Thanks

Answer:Excel Help - Cross check columns

Hi,This macro takes the data in column A in worksheets named "Sheet1", "Sheet2" and "Sheet3",and tests if the data in column A exists in column A of worksheet "Sheet4"If the data is not present, then the entire row from the source worksheet (Sheet1, Sheet2 or Sheet3) is copied to the next available row on Sheet4.Finally the data on Sheet4 is sorted based on the data in column A.You did not say where your data was held, so this macro is based on the following assumptions:1. All data starts on Row 2 of the respective worksheets.2. Column A contains data that can be compared, and can be used to identify the row of data uniquely, e.g., ID number, but it could be name if the data is unique - first and last names in same cell.To run the macro, I suggest you add a button to your destination worksheet - "Sheet4"From the Ribbon select Developer (If it's not visible go to the Office Button, select Excel options at the bottom and select the Popular tab and check the 'Show Developer tab in the Ribbon' box)In Developer - Controls select Insert and choose the button icon.Draw the button on the worksheetIn the 'Assign Macro' dialog box select 'New'In the code window that opens enter this:Option Explicit

Sub Button1_Click()
Dim rngStart As Range
Dim rngEnd As Range
Dim rngSrcCell As Range
Dim rngDestCell As Range
Dim rngDestStart As Range
Dim intDestOffst As Integer
Dim strShtNme As String
Dim blnExists As Boolean
Dim n As Integer

On Error GoTo ErrHnd

'turn screen updating off
Applicatio... Read more

2 more replies
Relevance 65.19%

I have created a user form in which i have added VBA coding to prevent the possibility of the user being able to insert letters into the field. At current i have inserted the following cases: Case 32, 48 To 57What case do i need to insert in order to allow the user to insert a dot ('.') into a text box on a user form. This field is for a price and therefore, a dot is required so that the price can be separated and placed to two decimal places-e.g. 45.99Thanks your help would be appreciated!

Answer:Excel- Type check- VBA coding

TryCase 32, 46, 48 To 57but it might be better to invert your logic and exclude the ANSI codes for numbers - 48-57.

4 more replies
Relevance 65.19%

Hi.

I am wanting to know if its possible to write some VBA to check the contents of a Cell to see if it contains any of a given list of text. The given list would either be on a different sheet in the same workbook or hardcoded into VBA, preferably on a different sheet though.

If the cell doesnt match, then it would carry on and check one last thing before it transfers the whole row to a different sheet. This has already been coded and is working.

Any help would be appreciated.

Thanks

Lightingman2003
 

Answer:Excel VBA Check if a string contains given text.

Try this function

Code:
Function CheckText(CellToCheck As Range) As Boolean
Dim CheckRange As Range, Hit As Range

'***************************************************************
'definition of checkrange should be modified as needed
[B]Set CheckRange = Workbooks("my workbook.xls").Sheets("CheckList").Range("A1:A100")[/B]
'***************************************************************
Set Hit = CheckRange.Find(what:=CellToCheck.Value, LookIn:=xlValues, Lookat:=xlWhole, MatchCase:=False)
CheckText = Not (Hit Is Nothing)
End Function
Usage:
There must be a range somewhere that contains the list of texts. The exact location of the range must be defined in the code line surrounded with ****** .
The input argument of the function is the cell that should be checked against the list.
The function returns true if the cell's value is found in the checklist, and false otherwise. The LookAt and MatchCase flags define whether the code looks for partial or whole text match and whether it differentiates between lower and upper case characters.

Hope this helps.

Jimmy
 

3 more replies
Relevance 64.37%

I have listbox with check box as listbox items, i need to select to checkox dynamically. help me to do this.

Answer:Unable to check the check box dynamically in listbox in wp7

sorry but I clearly didn't get your question here. Could please give me some more details ? :)

2 more replies
Relevance 64.37%

So I have this problem, I have a user that have to check that box every time he open outlook for always check spelling before sending, it won't save the setting when I close it, my last resort would be a new profile but I want to try get help here first since google wasn't very helpful

We use outlook 2010 and the PC is part of a domain, I also tried checking the web outlook but the option is not there.

He is the only user having this problem and to be honest I have never seen this problem before.

More replies
Relevance 64.37%

Sup ppl?

I've been trying to get chech disk to run on startup for about a month now with now succes. I've searched the net constantly and tried tons of different approaches, but they all failed for me.

Anyway, I keep getting a baloon popup saying I should run chech disk because I have errors. I was hoping there's any type of software I can buy/download that will do the same thing as Check Disk, as in fix errors and bad sectors on disk.

Thanks in advance ppl.


-Des
 

Answer:Check Disk \ Auto Check Alternatives

Well...? I'm sure there must be some available.

-Des
 

7 more replies
Relevance 64.37%

Hey guys,

The company I'm working for has grown a lot and now I'm no longer the only programmer. We're looking for an app that lets us do code check-in/check-out that'll also store all the changes.

All the files we need monitored are plaintext, and we do most of our development in Notepad or Notepad++. The app must work in Server 2003.

Any suggestions?

Thanks!
 

Answer:Code Repository/Check-in/Check-out system

I think subversion should handle your needs...
 

13 more replies
Relevance 64.37%

If it ain't one thing, it is another with this computer.
My spell check is having a nervous breakdown. It checks and offers alternatives for almost every word. This check can include words such as A or An, It, etc. At times I get spellings for words nowhere similar
In a paragraph similar in length to the preceding one, I might have suggetions for practically every word.
Plus, the auto check feature is not working
Anyone help? Appreciate any

Sarge
 

Answer:Spell check doesn't check correctly

You need to tell us what OS you are using and where this is happening - in a browser, in a word processor etc.
 

4 more replies
Relevance 64.37%

What is the best check -in check-out asset management software? A list of what's out there would be appreciated because I cant seem to find an authoritative one of what's best for asset management (game development). I hear Alien brain is good and there's one that starts with a 'p' that I can't remember the name of it to save my life... Alien brain is too expensive and hard to find. It's an open source project so I know the 'p' one would work because they offer open source licenses so if anyone knows what Im talking about feel free to enlighten me.

Something similar to Project but with asset management and check in/check out functionality would be great if anyone could suggest something. A step beyond that would be real time preview of maya scenes, psds, and xsi files. But maybe I want too much with the latter...

edit: Oh and it doesn't have to be free, Im just curious as to what's out there...
 

More replies
Relevance 64.37%

Hello.

I have a SuperMicro server with windows 7 32bit. I am using a specialized hardware that can understandably may cause machine check errors because I have a pcie device that can stop responding to cpu non posted transactions for long pepriod of time. I have disabled the pcie timeouts in the hardware, but some other cpu exception occurs due to this long waiting time for the pcie transaction to complete. I get the BSOD with WHEA exception 124.
Bug Check 0x124: WHEA_UNCORRECTABLE_ERROR

Reported by compenent: Processor Core
Error source : 3
Error type: 9
Processor ID: 36

Event ID 18

How do I disable this machine check in windows 7 ?

Thanks

Rayyan

Answer:how to DISABLE Machine Check, WHEA bug check

Hello and welcome to the sevens forum. You said you are getting BSOD"s can you do the following because the BSOD team will need it to help you.

Blue Screen of Death (BSOD) Posting Instructions

1 more replies
Relevance 64.37%

Sup ppl?

I've been trying to get chech disk to run on startup for about a month now with now succes. I've searched the net constantly and tried tons of different approaches, but they all failed for me.

Anyway, I keep getting a baloon popup saying I should run chech disk because I have errors. I was hoping there's any type of software I can buy/download that will do the same thing as Check Disk, as in fix errors and bad sectors on disk.

Thanks in advance ppl.


-Des

Answer:Check Disk \ Auto Check Alternatives

There isn't any such software??

-Des

3 more replies
Relevance 64.37%

I want to check column A rows 5-18 against a table in vba and if matches, insert DS into the cell. I have a list of names in A5-A18 and the days (1/1/12-6/3-/12) across the top in row 4. My IF is trying to check if colmun A name is equal to the Vlookup table for the matching date and Name2 (Date Day Name1 Name2). Any advise would be appreciated.
Code:

fRow = 4
fCol = 1
For iCol = 2 To 185
For iRow = 5 To 18
If Cells(iRow, fCol).Value = "VLOOKUP(cells(fRow, iCol),R1C201:R399C204,4)" Then
Cells(iRow, iCol) = "DS"
End If
Next iRow
Next iCol
 

Answer:Excel VBA Check if cellvalue = formula results

12 more replies
Relevance 64.37%

Hi, I am trying to to get a bullet to appear in a cell when it is selected. If a cell is selected in the same column the first bullet or check should disappear and a new one appear in the newly selected cell. I only want this to operate for C145:V164 and for each column in this range (C-V)Any Help greatly appreciated. Thanks.John

Answer:Selecting excel cell makes check appear

What exactly do you mean by "get a bullet to appear in a cell when it is selected"?Do these cells have data in them and the "bullet" should appear along with the data? Are the cells empty and should contain just a bullet when selected? Will the bullet be used for something once it is the cell?Please give us some details as to what you are trying accomplish.

12 more replies
Relevance 64.37%

I have an Excel 2003 spreadsheet which runs as a batch system loading other spreadsheets and running macros contained within. Problem is they are shared over a network and occasionally the digital signature is changed/corrupted so the whole thing stops. Is there any way in VBA of checking before/after a spreadsheet is opened that the certificate is ok? I can use vbasigned to check one is present but how do I check it is authorised?
 

More replies
Relevance 64.37%

Good afternoon,

I use a spread sheet which contains Check Boxes, that I manually tick to show a task has been fully completed. I have a basic formula that calculates returned items, and once it reaches 0 (all returned) I tick the box. I wish to have the Check Box auto-tick itself once the returned items count reaches 0. I'm damned certain this is possible, but beyond my abilities. I know you can have formulas to display text once a Check Box is ticked, I am kinda trying to do it the other way around.

Thanks for any help

Darren
 

Answer:Microsoft Office Excel 2010 Check Box

Darrenbilly said:





I'm damned certain this is possible, but beyond my abilities.Click to expand...

You are correct, it is possible.

What you need to do is learn the Visual Basic for Applications coding in Excel. Then you can add code that runs every time the sheet calculates (basically when something changes on the page). The code can check the status of a cell and change the status of another cell (or object in your case) based on criteria you have coded.

I'm not a programmer but playing with Excel Macros (VBA coding) and manipulating excel cells is a long time hobby of mine.

The easiest way to learn is to record Macro's and then study the code. It is easier learning the code if know first hand what it does. After you are familiar with how the code works, you will be surprised at how easy it is to code your own macros. Once you have the macro working for you, it is easy to move the code and have it run every time the sheet loads, calculates, closes, or several other possibilities.
 

10 more replies
Relevance 64.37%

Hi,I have number values in columns F and N and I would like that data to be put onto the same row and then the row to be deleted if the same value appears in both columns F and N; or if the values are not in both columns that data is copied into a new sheet. The data starts on row 1. Thanks

Answer:Excel Help - Macro to cross check 2 columns

I'm confused.What data do you want put on the same row?Is there data in other columns besides F and N? If so, what happens to that data when the values in F and N are lined up?Perhap you should post some example data of your "before" and "after" so we can see what you are requesting.Please click on the following line and read the instructions on how to post data in this forum. Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 64.37%

Doing research and need to check if pairs of twins have answered 3 question in the same way. Help much appreciated :) A person has an own row, with personal code followed by answers. I somehow need to match two codes and then see if the answers of these code pairs match. ex.XDX. 1, 0, 1VGD. 1, 0, 1Sunday greetings from a confused thesis writermessage edited by AnnieHuh

Answer:How to check if answers of pairs match in excel?

First, a posting tip:Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.Thanks! For now, I am going to assume that your data looks like this:
A B C D
1 XDX. 1 0 1
2 VGD. 1 0 1If that is the case, the following formula will compare B1 with B2, C1 with C2 and D1 with D2. If all of those comparisons are TRUE, the IF will be TRUE and the formula will return the word "Match".The AND function requires that all logical tests within the parenthesis be TRUE for the AND to be TRUE.=IF(AND(B1=B2,C1=C2,D1=D2),"Match","No Match")If I am misunderstanding your question, just let me know.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 64.37%

I want to increase the size of the check box but the only thing that increases in size is the box that has the check box and label in it.  I just want the check box itself to be bigger.  Also, is there a way to easily add or copy the check box down a column?  I don't need any labels.  I just want to have a column in a spreadsheet that I can click if certain bills are paid.  This way I can know which bills still need to be paid.  Thanks.I am new to this forum and can't find Microsoft Office as a category.  I posted this in Windows 10 but was looking for a sub-category for Excel.  I didn't see it under software.  Am I missing something but it just seems that there isn't much organization for categories and sub-categories.  This means you have to search thru hundreds of posts to find anything that might be vaguely similar to what you are looking for.  Again, I am a newbie here and don't want to ruffle any feathers.  I just want to know where to find subcategories I am looking for, like MS Office ->Excel ->2016.

Answer:How do I increase the size of a check box in Excel 2016

Early version s of Excel will work the same way for basic settings.Here is a starting place:http://www.dummies.com/how-to/computers-software/ms-office/excel.htmlAnd this is the official Microsoft  guide:http://www.skilledup.com/articles/learning-excel-guideThis is a video specific to your needs:https://www.youtube.com/watch?v=BX9ycMj5F_IBow to put a tick  box in a cell, watch this:https://www.youtube.com/watch?v=8kI7_kmxZmkNext, how to resize it:https://www.youtube.com/watch?v=Uw70JyA4QHoHope that helps.   

3 more replies
Relevance 64.37%

The Check List contains a list of subject(items) ),and there are the following columns named (20%,40%,60%,80%,100%, Not Required), the idea is that the user wants to select the percentage of the interested topics by check or enter for example a cross sign in the cell and after that i want to make a function that checks that loop through each row to check that there is only one entry, For example if the user selects for the same topic or put a sign cross inside the cell which corresponds to the percentage Column 20% and then he puts another check inside the percentage column 40%, then the previous check must be removed from the column percentage 20% and the same for whole rows. Can anybody help Please ? Any help is appreciated

Answer:I have an Excel worksheet, let's say a Check List template

It would appear that to do what you want, in the manner you want, you will need a Macro.But why not just have your Topics in Column A and in corresponding cells in Column B have drop-down lists with the percentages?No need for checking marking a third cell.MIKEhttp://www.skeptic.com/

12 more replies
Relevance 64.37%

simply I will have a front page which details names / acoount numbers references etc. Then there will be a list of different forms with a check box. When I tick the check box I want it to populate all the relevant sheet within the workbook witht he data from the front page. Woudl I need to do a macro for this? if so how do I do it? I have a rough idea but would I be able to just click record macro and start from there?

Answer:Excel - pre populate pages after ticking a check box

Yes you need a macro. And yes, recording a macro is generally the best way to start. If you don't have a book on VBA, you should probably get one. John Walkenbach's is pretty comprehensive.

2 more replies
Relevance 64.37%

Hi, I need to check data in 2 different spreadsheet, to know if the data match. I need it checked & need to know which cells are not matching. Tried using VLookup but did not help

Answer:Cross Check excel data in 2 different spread

We're sorry to hear that VLOOKUP did not work.Be sure to let us know what you try next.

2 more replies
Relevance 64.37%

Currently I have a data validation drop down list in Excel where you can only select one list item. I want users to be able to select multiple items from this list, and have it show in the single cell separated by comma. I've read you can do this with VBA but I'm not familiar with VBA in Excel. If anyone knows another way to do this, or some step by step instructions you could link to about how to do it with VBA, I'm pretty technical so with a little guidance should be able to figure it out.
 

More replies
Relevance 64.37%

It has been a very long time since I wrote macros in Excel ... I can easily be called a noobie at this point.

Let me first explain what I have:

I have an Excel document that has an unknown number of sheets ... i.e., I do not know the number of sheets without counting them.
Rev_0 of the document has the numerical value 2.09 in cell B107 in all of the sheets.
Rev_1 of the document is supposed to have the numerical value 0.36 in cell B107 in all of the sheets.
There are no other changes between Rev_0 and Rev_1 of the documents
What I want to do is:

Have a macro that steps through each of the sheets in the document without me telling it the number of sheets.
Log the numerical value in cell B107 in each of the sheets.
On the empty sheet where I launch the macro, the macro writes the sheet number in Column A and the corresponding cell B107 numerical value in Column B.
My goal is to confirm the value in cell B107 for each of the sheets. How would I code the macro?

Thank you!
 

Answer:Check Numerical Values in Excel Sheets

Welcome to board

Try this code. Haven't tested, but it should work.

Code:
Sub Check()
Dim ws As Worksheet, tws As Worksheet
Dim rng As Range

Set tws = ActiveSheet
For Each ws In ThisWorkbook.Worksheets
If tws.Name <> ws.Name Then
Set rng = tws.Range("A" & Rows.Count).End(xlUp).Offset(1)
rng = ws.Index
rng.Offset(, 1) = ws.Range("B107")
End If
Next
End Sub
Jimmy
 

1 more replies
Relevance 64.37%

I have a schedule control Excel sheet, such as below Item Task Start End "predecessor task"1 Gather requirement 2016/5/3 2016/5/9 2 UI Design 2016/5/6 2016/5/22 3 Coding 2016/5/18 2016/6/20 4 Unit tests 2016/5/11 2016/5/18 5 System test 2016/5/18 2016/6/1 6 Beta 1 2016/5/30 2016/5/31 7 Bug fixes 2016/6/3 2016/6/26 5 8 Improvements 2016/6/17 2016/7/6 9 Final testing 2016/7/2 2016/7/10 10 UAT 2016/7/1 2016/7/25 7 11 Release version 2016/7/26 2016/8/4 some task need to start after another task, such task 7 start after task 5 finished, task 10 start after task 7 finished. if I input predecessor 5 at the task 7, then the start date of task 7 need to set the task end date + 1 if the start date of task 7 <= the end date of task 5. how to write the EXCEL function or VBA to resolve this issue. if the start date of task 7 changed, the following start date of tasks changed if these task have predecessor setting and need to changed if need.that is the start date and end date of task 7 changed, the task 10 may changed , if the end date of task 7 > start date of task 10. please assist me, thanks!!

Answer:Check & set the start date after another task end in excel

What are the "predecessor task" for all of the tasks?Do they have a set sequence?Why can't you just list them in the sequence that needs to be followed?Also, Excel questions are best asked in the Office Software forum.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 64.37%

Hello folks, I have a number of sheets where I want to have a check box linked to a cell, in fact I want a column of these. When I link the box to the cell and click and drag that cell down the column, it creates the check boxes but the cell link remains constant at the original cell, it does not drag the formula and increment to the next cell. Is there a way of doing this?Cheers

Answer:Excel click and drag check box formula

Look in the formula for the original cell. If there are $ signs, remove them as this tells Excel it is an absolute reference and will not replicate for cells in order.RegardsFitshase

10 more replies
Relevance 64.37%

I am looking to write a Macro that will search the first row of a table of data (the row containing the collumn headings) for 5 specificly named headings (call them Heading1, heading2 etc...), and only IF all of those headings are found,continue to run the rest of the macro. Otherwise give an error or exit the macro. The Macro itself runs a series of calculations and looks up information from the table to compile it into more managable data, but if all of the required collumns are not their then it will return an error and this causes me problems. I want to pre-empt the error and prevent the macro from executing. Thank you in advance. Finley

Answer:Macro to check for column before executing - EXCEL

You can certainly check for the Column Heading within the macro or you can use a Error Handling routine with On Error. With On Error you can force the Macro to stop execution or present a message to the user about the mssing column or basically do whatever you want it to do when an error occurs. You can even test the error value and do different things based on what error occurred. Look up the On Error statement in the VBA Help files or via Google. Using error handling routines is very powerful.If all you want to do is check for the Column heading and exit the macro if the heading isn't found, this is one of the many ways it can be done:Sub FindColumnHeading()
With Range("B5:N5")
Set c = .Find("MyColumnHeading")
If c Is Nothing Then Exit Sub
End With
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 64.37%

I want to increase the size of the check box but the only thing that increases in size is the box that has the check box and label in it.  I just want the check box itself to be bigger.  Also, is there a way to easily add or copy the check box down a column?  I don't need any labels.  I just want to have a column in a spreadsheet that I can click if certain bills are paid.  This way I can know which bills still need to be paid.  Thanks.I am new to this forum and can't find Microsoft Office as a category.  I posted this in Windows 10 but was looking for a sub-category for Excel.  I didn't see it under software.  Am I missing something but it just seems that there isn't much organization for categories and sub-categories.  This means you have to search thru hundreds of posts to find anything that might be vaguely similar to what you are looking for.  Again, I am a newbie here and don't want to ruffle any feathers.  I just want to know where to find subcategories I am looking for, like MS Office ->Excel ->2016.

Answer:How do I increase the size of a check box in Excel 2016

Early version s of Excel will work the same way for basic settings.Here is a starting place:http://www.dummies.com/how-to/computers-software/ms-office/excel.htmlAnd this is the official Microsoft  guide:http://www.skilledup.com/articles/learning-excel-guideThis is a video specific to your needs:https://www.youtube.com/watch?v=BX9ycMj5F_IBow to put a tick  box in a cell, watch this:https://www.youtube.com/watch?v=8kI7_kmxZmkNext, how to resize it:https://www.youtube.com/watch?v=Uw70JyA4QHoHope that helps.   

3 more replies
Relevance 64.37%

Hi,I am kinda of new to Excel and I have a question.Here is my example:Cell"B1" Contains letters and numbers (anywhere from 1 to 32 characters).If the first 5 characters in "B1" = 11111* then I want Green to print in A1However if the first 5 characters are 1azxc* then I want it to print Blue in A1.However if the first 2 characters are 99* then I want it to print yellow in A1.Can someone help me with trying to code this.Any help is greatly appreicated.Regards,Keith

Answer:Excel-Check Data in one cell write to another

You didn't say what you want to appear in A1 if none of the 3 conditions exist.This formula will present a text string if none of the values were found.=IF(LEFT(B1,2)="99", "yellow", IF(LEFT(B1,5)="1azxc", "Blue", IF(LEFT(B1,5) = "11111", "Green", "No 99 or 1azxc or 11111")))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 64.37%

Is there a visual check for locked cells in excel?I am the author and maintenance man for a rather complicated excel spreadsheet Many cells are locked but they are widely distributed in the spreadsheet. I remember that over twenty years ago, that in Supercalc, when a cell was locked there was a visible indicator of the fact but I cannot find a way to make excel do the same.It is a frustrating job trying to check what is locked and what isn't. Surely excel ought to have a facility for this. Can anyone help?

Answer:is there a visual check for locked cells in excel?

Select the cell, select format, remove the tick in 'locked'

3 more replies
Relevance 63.55%

Hi,Is it possible to have a Check Box (Form Control) appear/disappear in a cell by selecting a value from a dropdown menu? For example: I have my dropdown menu in cell b2. Based on certain dropdown values, I would like different Check Boxes to appear in B4-B6.Meaning, if B2=?Apple?, I need B4 to have a check box to enable ?Granny Smith?, B5 to have a check box to enable ?Pink Lady?, and B6 to have a check box to enable ?Fuji?. But if B2=?Grape?, I need B4 to have a check box to enable ?Green? and B5 to have a check box to enable ?Purple?.I am open to using other types of form controls or coding to make this happen?it?s just that my knowledge in that area is slim.Appreciate the assistance!

Answer:Excel 2010 | Check Box (Form Control) appear/disappear

I don't do much with Form Controls, but perhaps you can use the Worksheet_Change event to accomplish your goal.The Worksheet_Change event fires whenever a change is made to the worksheet in which it resides.A Worksheet_Change event looks something like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
MsgBox "Cell B2 Was Changed!"
End If
End SubObviously you would change the MsgBox instruction to show your Form Control.To check for different values in B2, you would use more If's:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then

If Target = "Apple" Then
MsgBox "B2 Now Shows Apple"
End If

If Target = "Grape" Then
MsgBox "B2 Now Shows Grape"
End If

End If
End Sub
I hope that helps.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 63.55%

On a monthly basis, we will receive a new data file.
The user will copy the data from this file and paste it into a blank template file that I've set up. When the user pastes the new data into cell A2, he will then Save As, so as to preserve the original template file in its blank condition for use the following month.

The template file basically consists of an Excel Table, so that the data range can expand, formuale within boilerplate columns will automatically calculate, and the range used by pivot tables in the workbook will all resize nicely.
All going swimmingly so far.

However, I've come across a stumbling block. Certain records have duplicate values in multiple (though not all) columns. Where this is the case, I need to display only one instance of the value in a new column.

So, I have the following columns:

A: Job ID
B: Staff member
C: Work Area
E: Work Started
F: Work Finished
Q: Time Taken
R: <my formuale result>

with some other data in columns D and G thru P.

I need either a formulae or VB code that will enter the following in column R:

- For records (rows) where any of these values are non-duplicates, return the Time Taken.
- For records where the values in all of those columns (A AND B AND C AND E AND F) are duplicated, only return the Time Taken for the first instance.

In other words, say I had the following data:

_____A_____B_____C_____E_____F____Q_____R
1____ID_____NAME___AREA__STRT___END__TIME___CALC
2____abc____JON____A01___10am___11... Read more

Answer:Excel 2007 Check for duplicate in several columns and return a value

Howdy stranger!

So if you used:

=A2&B2&C2&E2&F2

in (say) S2 and down, you could then use:

=IF(COUNTIF(S$2:S2,S2)=1,1/24,0)

in R2 and down?
Edit: 2nd should be =IF(COUNTIF(S$2:S2,S2)=1,G2,0)
 

2 more replies
Relevance 63.55%

Hello ,

I have one excel file with one column with expires date.
I want script or something else to check every day this excel and if one cell is small than 10 then
run a batch file (i have it) with blat emailer (command line emailer) to send me email.
Is it possible ?
 

Answer:Script to check column of excel and send email.

16 more replies
Relevance 63.55%

HiI'm still really new to VB, but I'm writing a macro which copies data from spreadsheet to another when a submit button is clicked. However, because two people could be trying to do this at the same time, I want to include at the beginning of the macro a process where it checks whether the file needed is already open by someone else. If the file is open, I need it to create a message box asking the user to try clicking submit again in a couple of minutes, with the vbOKonly option.If the file is not already open, I want the macro to continue running. Any help would be much appreciated, as I'm going round in circles :-)

Answer:Macro needed to check Excel file open

Define "the file."How To Ask Questions The Smart Way

5 more replies
Relevance 63.55%

I want to run a macro in Excel 2003 that will check whether a cell has been completed, and if so, proceed to another worksheet. If the cell has not been completed, I want it to bring up a message to explain what needs to be completed. I'm still very new to VBA! So any help would be appreciated. Thanks

Answer:Excel - Macro to check cell contents complete

As a generic example, this will check A1:A10 and each time it finds an empty cell, it will present a message box.I know that this won't fit your needs, but you didn't provide very much detail. It's just an example of how it could be done.
Sub CheckCells()
For rw = 1 To 10
If Cells(rw, "A") = "" Then
MsgBox "Cell " & Cells(rw, "A").Address & " is incomplete"
End If
Next
End Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 63.55%

Hai,
I had problem with my List Box Active Control Check Box.
Can anybody assist me why is that when I thick required info required at my individual list box only
certain info is copied to dedicated row.
File attached as reference.
Thanks
 

Answer:Excel Form ListBox Check Box Axtive Control

No idea what you mean, there are many listboxes so which one is causing you the problem and what is actually happening/not happening?

tell us exactly what you enter into the fields and which options you are ticking and then we can narrow down the problem
 

1 more replies
Relevance 63.55%

Hi,

I have a workbook with 3 columns.

Column 1: Network address
Column 2: Subnet bits
Column 3 An IP address

For each row, need to check if the IP address in column 3 is within the IP range specified by columns 1 and 2.

If the IP address in column 3 falls within the range represented by values in column 1 and 3 need to display TRUE in column 4 of that row. Otherwise need to display FALSE.

Anyone who is able to do this using formulas only is a genius but VBA solutions are also welcome! Thanks!
 

Answer:Solved: Use Excel to check if an IP address is within a given range if addresses

I don't think this is quite so hard as you make out (for formulae), but anyone who wants to help will need more information. What format are you putting the addresses and subnet bits. Better still can you please post a sample spreadsheet?
 

3 more replies
Relevance 63.14%

I have just started to build a form and have added chck boxes Yes and No into the form. How do I link the 2 boxes so that only yes or no can be answered for the question.How do I link the size of the check box to the cell size.I have looked at properties in design mode and can't see anything that looks obvious.Can anyone help?

More replies
Relevance 63.14%

What can I use (formula, etc) to check if a cell has a fill color or not? I have thousands of records with some with a yellow fill color. I need to move those that are filled to another sheet.
 

Answer:Solved: Excel: Formula to check cell color highlight?

8 more replies
Relevance 63.14%

This one has me tearing my hair out :

I need to calculate the check run date for vouchers processed on various dates. We run checks twice a week on Wednesday and Friday. Vouchers processed on Friday, Monday and Tuesday are paid on a Wednesday; Wednesday and Thursday vouchers are paid on Friday.

I have set up 3 columns and have defined names for them using the column title (Insert> Name> Define) :
Date - contains the dates to be used to calculate future check date
Day - contains text representing the day of the week
Weekday - contains the following formula =WEEKDAY(Date,2)

In a 4th column labeled "Check Date", I am using the following formula:
=IF(Date+3-Weekday<=Date,Date+5-Weekday,Date+3-Weekday)

Below are my results. It works fine except for all days except Friday, August 17 where the check date should be the following Wednesday, August 22.

Date Day Weekday Check Date
13-Aug Mon 1 15-Aug
14-Aug Tue 2 15-Aug
15-Aug Wed 3 17-Aug
16-Aug Thu 4 17-Aug
17-Aug Fri 5 17-Aug

Does anyone have a solution that will give the right check date in all cases? Any and all advice much appreciated...

Susan
 

Answer:Excel - Calculate Check Date using Semi-Weekly Schedule

8 more replies
Relevance 63.14%

Hi all,

I need help to validate that the data in excel column is always a 4 characters alphanumeric only.
eg: abc1
ADG2
123R
1we2
2WER
3ER3
etc
Kindly help in this by giving function to accomplish this check.
thanks in advance.
 

Answer:4 characters alphanumeric data validation check on one excel column.

Welcome to the forum

LEN(A1)=4 would give you the length, so you could combine it with another formula using AND to only allow letters and numbers.
 

3 more replies
Relevance 63.14%

I've been tasked with coming up with a template for Job Site IT Setup costs and they've wanted it in an Excel document.

The document contains several components I need to work interchangeably:

List the different connectivity packages (Option A, Option B, etc)
List the Other Items independent of the chosen connectivity package
List the job length in months
Show "one-time" costs for each Option as well as Other Items
Show "monthly" costs for each Option as well as Other Items. This is subtotaled based on job length.
Show a Grand Total based on which Option and Other Items were selected in reference to the job length
I've got everything apart from that last part pretty solid. When I start trying to add check boxes, things get confusing.

What I'm looking to do is have the user to select which Option they want with a check box. This would use that particular Option's value towards the Grand Total.

Afterwards, I want the user to be able to select which Other Items they want to add (either "one-time cost" or "monthly") with check boxes as well, adding that amount towards the Grand Total.

Right now, I'm having trouble trying to get the particular Option's to add with the Other Items subtotal into the Grand Total cell. I have a feeling I'm close (though my methods might be messy), but I just can't find the right formula structure. Please refer to the attached document for reference.

Any help or... Read more

Answer:Excel 2010: Check Boxes for Adding Values to Formula

11 more replies