សេកមាស បន្ទាយមានជ័យ

អាស័យដ្ឋានៈ ទីតាំងទី​‌១ នៅទល់មុខសាលាសូភី ខាងជើងភ្លើងស្តុប៧០ម៉ែត្រ​ ក្រុងសិរីសោភ័ណ ខេត្តប.ជ ។

Tel: 012 89 52 53 / 098 353 555 | E-mail: Sekmeas_bmc@yahoo.com

Wednesday, September 25, 2013

ឧបករណ៍ចាប់ LCD ជាមួយជញ្ជាំង

http://www.3vcambodia.com/productDetail.php?cateID=28&productID=152...

របៀបដំណើរការកម្មវិធីជាមួយ Administrator

OPTION ONE "Run as administrator" using a Keyboard Shortcut NOTE: This will allow you to temporarily run a program as an administrator once until you close it. 1. Press and hold Ctrl+Shift while opening the program. 2. If prompted by UAC, then click on Yes to apply permission to allow the program to run with full permission as an Administrator....

Tuesday, September 24, 2013

ប្រើអ៊ីមែលជាមួយ MS Outlook 2010

បើក MS Outlook 2010 ចុច File => Add Account ជ្រើសរើស Manually configure server settings or additional server type រួចចុច Next ជ្រើសរើស Internet E-mail រួចចុច Next រួចធ្វើការបញ្ចូលដូចខាងក្រោម  · ត្រង់ព័ត៌មាន User Information  Your Name: ឈ្មោះរបស់យើង E-mail Address: ជាអ៊ីមែលរបស់យើង · ត្រង់ព័ត៌មាន...

ស្វែងយល់ពី Mail Server និង Mail Client

Mail Server គឺជាសេវាកម្មសម្រាប់ចាយចែក Email ទៅកាន់ម៉ាស៊ីនកូន (Client) សម្រាប់ធ្វើការប្រើប្រាស់ ។ Mail Server ត្រូវបានដំឡើងដោយ ប្រតិបត្តិការម៉ាស៊ីនមេ ដូចជា (Windows Server 2003, 2008, Ubuntu Server និងមានច្រើនទៀត) ។  Mail Server ឬក៏ត្រូវបានស្គាល់ថា Mail Transfer Agent គឺជាសេវាកម្មមួយ សម្រាប់គ្រប់គ្រងរាល់សំបុត្រទាំងឡាយ ដែលបានផ្ញើចេញ​...

Sunday, September 22, 2013

របៀបបិទ “Read-Only” Protected View ក្នុង Office 2010

ដំណើរការ បើ Excel 2010. ចុច File, Options, Trust Center ចុចប៊ូតុង Trust Center Settings ជ្រើសរើស Protected View Tab និង uncheck ទាំង 3 ប្រអប់ រួចជ្រើសរើស File Block Settings និង uncheck ប្រអប់ទាំងអស់ ចុច OK ជាការស្រេច៕...

Saturday, September 21, 2013

រលឹកពេលជិតដល់កាលកំណត់នៅលើ Excel

MS Excel: Macro to warn when a record will expire within 31 days in Excel 2003/XP/2000/97 Question: We work with subcontractors who have insurance certificates that expire at various dates. We store these certificates and expiry dates in Microsoft Excel 2003/XP/2000/97. Is there a way in Excel to warn me when a particular certificate is about to...

ដំណើការ Form ដោយស្វ័យប្រវត្តិ នៅលើ Excel

MS Excel: Automatically open a Form when spreadsheet is opened in Excel 2003/XP/2000/97 Question: In Microsoft Excel 2003/XP/2000/97, I have a form called UserForm1. How do I automatically open the form when the workbook is opened? Answer: There are several "events" available within an Excel spreadsheet where you can place VBA code. In your case,...

របៀបបំលែងពីតំលៃលុយទៅជាអក្សរ

How to convert a numeric value into English words in Excel បើកកម្មវិធី Excel រួចចុច Alt+F11 ដើម្បីបើក Visual Basic Editor   ចុច Insert ហើយយក Module ហើយ Copy កូដ ខាងក្រោមចូល Code: Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position...

កូដ VBA នៅលើ Excel

កូដបិទចុចកម្មវិធី Excel Sub CmdExit() ThisWorkbook.Save Application.Quit End Sub...

Friday, September 20, 2013

របៀបកំណត់ពណ៌លើ Row ឆ្លាស់គ្នា

ចូលទៅកាន់ Conditional Formatting, ឧទាហរណ៍ =ODD(ROW())=ROW() ឬ =Even(ROW())=ROW() ...

ចុចពីដងលើ Cell ទទួលបានសញ្ញាជ្រើសរើស

បើកកម្មវិធី Excel រួចចុច Alt+F11 ដើម្បីបើក Visual Basic Editor ចុចជ្រើសរើស Sheet ណាមួយដែលចង់ប្រើរូបមន្តនេះ រួច Copy កូដ ខាងក្រោមដូច ចូល Code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) '****************************************************************************************** '* Copyright by Sekmeas.blogspot.com...

Thursday, September 19, 2013

បិទ cut copy paste និង Right Click នៅលើ Excel

ដោយចុច Alt+F11 ដើម្បីបើក Visual Basic Editor ចុច ThisWorkbook រួច Copy កូដខាងក្រោមដូច '============================================= 'Sekmeas.blogspot.com =================== '============================================= Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next With Application .CellDragAndDrop = True .OnKey "^c" .OnKey "^v" .OnKey "^x" .OnKey "+{DEL}" .OnKey "^{INSERT}" .CutCopyMode = False End With Dim Ctrl As Office.CommandBarControl For Each Ctrl In Application.CommandBars.FindControls(ID:=19) 'copy  ...

របៀប Import និង Export កូដ VBA

Import and Export VBA code Copy the code in a Standard module of your workbook, if you just started with VBA see this page.Where do I paste the code that I find on the internet On this page you find some basic VBA code to Import and Export VBA code in Excel for Windows.You can use it to import modules/userforms to other Excel files or to update the code in other Excel files.Note: This example not Export/Import the code in sheet modules and from the Thisworkbook module.Tip: Check out also the two links in the "More Information"...

របៀបប្រើប្រាស Application.Run ក្នុង Excel

When you want to run a macro from an event or from another macro in the same workbook you can call the macro like this in your code : Call YourMacroNameYou do not have to use Call but I think it is clearer when you read the code that another macro is called.But what if you want to run a macro that is in another workbook or Add-In(File or add-in must be open).We can use Application.Run if we want that like this : Application.Run "Book1.xls!MyMacroName"If the workbook name includes spaces or some other particular characters it is...

របៀបបង្កើត និងប្រើប្រាស ឯកសារផ្ទាល់ខ្លួនជាមួយកូដ VBA

Information If you want that certain code is available in all your workbooks, then use your PERSONAL.XLS or in Excel 2007-2013 your PERSONAL.XLSB file. What is it:This is a hidden workbook that opens when you start Excel.The code you copy in this workbook is available in all workbooks that are open in Excel.Where is it:If it exists, you can...

របៀបចម្លងកូដដែលស្វែងរកបានពីអ៊ីនធឺណិត

Where do I paste the code that I find on the internet  When you want to try VBA code that you see in a Forum, Newsgroup or WebSite and you read:Paste the code in a General, Regular, Normal or Standard modulePaste the code in a Sheet modulePaste the code in the ThisWorkbook module And you have no idea where to paste the code then I hope...

Page 1 of 5312345Next
Pulpit rock Pulpit rock Pulpit rock Pulpit rock