- 31
- 74 121
rafitsolutions
Ghana
เข้าร่วมเมื่อ 13 ก.ย. 2021
RafIT Solution how-to videos is aimed at providing answers to various problems. Our videos showcase tips, tricks, tutorials, apps and reviews.
How to Add Right-Click (Context Menu) On Text Boxes
In today’s tutorial we are going to learn how to add a Right-Click shortcut PopUp Context menu to A Userform’s Texbox and be able to perform actions such as Copy, Cut, Paste and Undo which are an integral part of the Windows operating system and users of your applications expect to have them as well but unfortunately, they are absent from the VBA UserForm TextBox.
I will also show you how you can write a class module for all the textbox controls on the UserForm so that you will be able to apply the same code to all the textboxes on the form instead of adding the code to individual textboxes handler.
I will also show you how you can write a class module for all the textbox controls on the UserForm so that you will be able to apply the same code to all the textboxes on the form instead of adding the code to individual textboxes handler.
มุมมอง: 1 631
วีดีโอ
How to create Flashing/PopUp object Using VBA
มุมมอง 961ปีที่แล้ว
This tutorial shows how to create a flashing or pop up object on the UserForm using VBA. This can be used as a means of advertisement, or serve as an important reminder for an important message and communicate effectively with users of your application.
How to Remove Close ('X') Button from Title Bar
มุมมอง 2.2Kปีที่แล้ว
This tutorial, demonstrate to remove or hide UserForm’s ‘ X’ or Close Button from the UserForm’s Title Bar using Windows API Functions.
How to Make UserForm Transparent
มุมมอง 1.2Kปีที่แล้ว
In today’s tutorial, we are going to learn how to make Userform transparent and blend with the application background nicely. Using windows API Functions
How to Add Icon to UserForm's Title Bar
มุมมอง 1.9Kปีที่แล้ว
This video demonstrates how to Add an icon to a UserForm's title bar. Adding your icon to the title bar of the userform is necessary when you are building a custom application because it gives a feel of personalization, authenticity, a professional look and also promote brand. Make sure to watch this video to the end to learn how you can carry out this process.
Hide or Remove UserForm Title Bar
มุมมอง 2.5Kปีที่แล้ว
This tutorial shows how to hide or remove a UserForm Title Bar using the Window Handle API. In previous Tutorial I introduced you to Windows Application Programming Interface (API). Using the Windows API, you can develop applications that run successfully on all versions of Windows
Advance Way To Add Minimize & Maximize Button To UserForm Using API
มุมมอง 5Kปีที่แล้ว
This Tutorial describes a method that you can use to extend the functionality or appearance of VBA UserForms and make it more user friendly at run time.
Make Recurring Income With Excel
มุมมอง 1Kปีที่แล้ว
This tutorial, shows you how you can create quarterly, annual or biannual subscription plan for your excel work book, template, software or any other VBA application. So that you can continue to make recurring income from your excel VBA applications. Make sure to watch this video to the end to learn how you can learn to do this for free.
Hide Excel Bars Automatically
มุมมอง 418ปีที่แล้ว
This Tutorial shows how you can Automatically hide the Excel Formula Bar and other Menu Bars that comes with excel so that your application appears like a software when it is opened using VBA.
Dynamic Login Desing (Part 5) Show Worksheets on Login
มุมมอง 148ปีที่แล้ว
In this tutorial, we are going to learn how to get access to worksheets after login When the workbook opens, the user will not be able to get access to rest of the worksheets unless the user logs in with and activated account
Dynamic User Login Designs (Part 4) Login Logs and Records
มุมมอง 160ปีที่แล้ว
This tutorial shows how to add Login Logs and Records to a project so as to record the date and time when users accessed the file, template or software. This aspect ass a bit of security to our system and also prevents unauthorize users from accessing the file, template or software
Dynamic User Login Design (Part 3): How to create Simple User Login Form
มุมมอง 177ปีที่แล้ว
This tutorial shows you how you can create a user login in form in which the username and password has been coded onto the user form and users are not required t enter their own password or username before they can gain access to the workbook or application.
Dynaimc User Login (Part 2) Q & A: How to Generate Password for Users
มุมมอง 190ปีที่แล้ว
This Tutorial is as questions and answer section based on earlier Tutorial " How to Generate Activation Keys for Excel Applications". It describes how you can generate a more secure and not easily guessed password for users of our excel applications or software.
Dynamic Login Designs (Part 1) How to Reference User Name and Password Using Vlookup
มุมมอง 310ปีที่แล้ว
This Tutorial demonstrate how you can reference User Name and Password using Vlookup when creating a User Login Form. It is the first part of a series that explores the various ways of designing User Login Form for you VBA or Excel Applications.
Automate Insert & Embed Files into Excel Spreadsheet Using VBA
มุมมอง 6Kปีที่แล้ว
In this tutorial, I am going to show you how you can use VBA to attach any file type in MS Excel. We are going to be using the Object Linking and Embedding (OLE) to help us to achieve this since it allows for files/objects embed and link other programs in MS Excel
Part 5] How to Backup Files Automatically Using VBA
มุมมอง 1.7Kปีที่แล้ว
Part 5] How to Backup Files Automatically Using VBA
UserForm Animation (Part-5) How to Create Advance Count Down using VBA
มุมมอง 1.7Kปีที่แล้ว
UserForm Animation (Part-5) How to Create Advance Count Down using VBA
Part 4] How to Encrypt and Decrypt Strings and Characters Using VBA
มุมมอง 2.2Kปีที่แล้ว
Part 4] How to Encrypt and Decrypt Strings and Characters Using VBA
Part 3] How to get PC Name and HDD Serial Number Using VBA
มุมมอง 2.5Kปีที่แล้ว
Part 3] How to get PC Name and HDD Serial Number Using VBA
Part 2] How to Add Subscription Plan to Excel Application using VBA
มุมมอง 2.6Kปีที่แล้ว
Part 2] How to Add Subscription Plan to Excel Application using VBA
UserForm Animation (Part-4) How to Show and Hide Password Using VBA
มุมมอง 3.6K2 ปีที่แล้ว
UserForm Animation (Part-4) How to Show and Hide Password Using VBA
Userform Animation (Part-3) How to Create Slide Effect on Userform
มุมมอง 2.8K2 ปีที่แล้ว
Userform Animation (Part-3) How to Create Slide Effect on Userform
Userform Animation (Part -2) How to Create Button Move, Flyin and Floatin Effect
มุมมอง 4.9K2 ปีที่แล้ว
Userform Animation (Part -2) How to Create Button Move, Flyin and Floatin Effect
Part 2: How to Create an Alphabet App in Excel
มุมมอง 3982 ปีที่แล้ว
Part 2: How to Create an Alphabet App in Excel
Part 1] How to Create Activation Keys for Excel Applications
มุมมอง 8K2 ปีที่แล้ว
Part 1] How to Create Activation Keys for Excel Applications
How To Make A YouTube Intro for free in MS PowerPoint
มุมมอง 1752 ปีที่แล้ว
How To Make A TH-cam Intro for free in MS PowerPoint
Part 1: How to Create Text Reading App in Excel
มุมมอง 1.1K2 ปีที่แล้ว
Part 1: How to Create Text Reading App in Excel
Thank you, great video!
Wow! That is cool. But on other PCs 💻, the template still works even though the subscription was done on a different PC. The HDD serial couldn't stop the subscription from running. Is it possible to add validation of the HDD serial just like the validation of keys. Anyway, thanks.
How the title of userform is at the midle of your userf
thank you sir !
But if I open another form from the same form and then return the writing, it continues to move. Is there a way to stop it or keep it moving again?
thanks for this video , can you please help me , i am getting error after closing userform Run-time-Error Automation error The callee(server[ot server application]) is not available and disappeared; all connections are invalid. they call may have executed.
I have a form with 2 ListBok, how can I do to make only the 2 ListBox transparent
Wow!!! How can I get a copy?
thanks! i really works, but the problem it hide taskbar when in maximized mode. can you please help me on how to fix this in 64-bit operation system.
bro i have been following you for a long time. thanks for this!. can you please share 64-bit codes.
error when you cancel the embedding of attachment
I had an error after saving and running the code
it doesn't work
it doesn't work
Firstly, thank you very much Second: Unfortunately, I encountered a problem because I applied the code completely and it worked and I was able to copy, paste, etc But I noticed after a while that the code sometimes works and sometimes it does not. For example, when using the copy command, the letter C appears inside textboxes, and so on with the letters V, P, Z, and I do not know why.
Great 👍🏻 thanks 🙏
Vert nice tuts
Please avoid background music.
Worked. Thanks
Sorry Sir, I encounter “bad DLL calling convention” error 49 How can I resolve. Many thanks inadvance
Nice and useful trick Thank you ❤
greetings and respect. Thanks for your great tutorials. I used this code, but considering that my Windows is 64-bit, it gives an error that the code must be updated (performance error). The code can be modified to automatically detect whether Windows is 32 or 64 .
Congratulations on your videos and your channel. I wanted to ask you if you know of a method (similar to this one) that does not allow file sharing between several users. For example a way that allows you to use username and password provided on one pc and does not work if the file is shared on another pc even with the same username and password
I love this
how to show last login detail in userform
Can you please explain why do we need the function " getsheets"?
bro.. if both txtuser and txtpassword remain blank and click login button it gets successful login.. plz guide
plz guide
Unfortunately ,it does not work ,it gives compile error that : Variable not defined ( wHandle). How to solve ? Thank you
Dim wHandle as Long
Dim wHandle as Long
Thank you so much Sir
Sir please make videos on ms Access also
Thank you so much
you doing great help for excel community brother
video would be so much better if there were no background music.
Good work snr. Keep it up...
GOOD JOB
Incomplete Video.... Skipped Video near "randomstring = str" Add complete video or provide the Practice file.. Thank you
Set expired date 2023 to 31 March 2024. 1 April open the file ask password excel vba code. Please send me this code 🙏🙏
Sir clear or delete can not apply.how clear textbox in this way
Dear sir please practice file link
Wow such a beautiful work ❤❤❤❤❤❤❤ Lovely 🌹 Again thankyou
I keep getting this data error "Method or data member not found" and it highlights the .FolderExists Can you help? Thank you
Please go to Tools in the editor and then click on reference, scroll down to add the Microsoft Scripting Runtime by checking the checkbox. That's if you have not enabled the reference yet.
Thank you very much for the informative video which made me understand the applicability of class modules. When you have time may you please demonstrate how one can use a class module say if there is a group of command boxes and when the mouse is over the command button, backcolor is yellow and when mouse moves away backcolor changes green as an example? Would really appreciate a video demonstrating that.
Sure I would.
Excel safety is weak so it is difficult to protect
Yes it is but you can certainly get around it.
Thanks you 👍🙏
Welcome 👍
thanks you souch , I am Shahidul from Bangladesh ❤. hoop you better life 💪
Thank you too.
Courage.....
I appreciate it very much. Thank you for the encouragement.
Cogratulation! Goog job.
Thank you very much.
بھائی جان۔۔ کوڈنگ کے دوران ماوس کرسر تو سائیڈ پہ رکھ دیا کریں۔۔شکریہ
Well, I can not read Arabic however, I am delighted that you reached out to me. Thank you very much.
teach us how to create school management system
Thank you for your interest. I will do that soon.
Bro I have tried it and it work properly . Be blessed . My request to you is that .how can you make it to appear and disappear for every second . From TANZANIA 🇹🇿
If I may, which item would you want to apear an disappear every second?
@@rafitsolutions4533 Thanks for quick response. Just for label1 (the date). Make it appear and disappear just like car's 🚙 indicator. For example one second it appear then disappear and it keeps doing so infinitely. Thanks.
Ok
Watch this Tutorial for answer: th-cam.com/video/Zu1rGl83T9Q/w-d-xo.html
@@rafitsolutions4533 Bro thanks a lot you are a legend when It comes to VBA CODING. welcome in Tanzania 🇹🇿 🛫🛬