rafitsolutions
rafitsolutions
  • 31
  • 72 201
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.
มุมมอง: 1 524

วีดีโอ

How to create Flashing/PopUp object Using VBA
มุมมอง 892ปีที่แล้ว
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
มุมมอง 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.8Kปีที่แล้ว
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.4Kปีที่แล้ว
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
มุมมอง 993ปีที่แล้ว
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
มุมมอง 395ปีที่แล้ว
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
มุมมอง 159ปีที่แล้ว
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
มุมมอง 176ปีที่แล้ว
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
มุมมอง 189ปีที่แล้ว
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
มุมมอง 304ปีที่แล้ว
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.6Kปีที่แล้ว
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.1Kปีที่แล้ว
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.4Kปีที่แล้ว
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.5Kปีที่แล้ว
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.6Kปีที่แล้ว
UserForm Animation (Part-4) How to Show and Hide Password Using VBA
Userform Animation (Part-3) How to Create Slide Effect on Userform
มุมมอง 2.7Kปีที่แล้ว
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.7Kปีที่แล้ว
Userform Animation (Part -2) How to Create Button Move, Flyin and Floatin Effect
Part 2: How to Create an Alphabet App in Excel
มุมมอง 3972 ปีที่แล้ว
Part 2: How to Create an Alphabet App in Excel
Part 1] How to Create Activation Keys for Excel Applications
มุมมอง 7K2 ปีที่แล้ว
Part 1] How to Create Activation Keys for Excel Applications
Up Coming Series
มุมมอง 682 ปีที่แล้ว
Up Coming Series
How To Make A YouTube Intro for free in MS PowerPoint
มุมมอง 1732 ปีที่แล้ว
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
Overview of Rafit School Manager
มุมมอง 3582 ปีที่แล้ว
Overview of Rafit School Manager
Create Splash Screen in Excel
มุมมอง 3K2 ปีที่แล้ว
Create Splash Screen in Excel

ความคิดเห็น

  • @AlatiphA
    @AlatiphA 18 วันที่ผ่านมา

    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.

  • @broudjzed7892
    @broudjzed7892 29 วันที่ผ่านมา

    How the title of userform is at the midle of your userf

  • @minhho1833
    @minhho1833 หลายเดือนก่อน

    thank you sir !

  • @anon-design
    @anon-design หลายเดือนก่อน

    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?

  • @anirudhajoshi-h1g
    @anirudhajoshi-h1g 2 หลายเดือนก่อน

    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.

  • @edwinjoachin6240
    @edwinjoachin6240 2 หลายเดือนก่อน

    I have a form with 2 ListBok, how can I do to make only the 2 ListBox transparent

  • @enochaffum27
    @enochaffum27 2 หลายเดือนก่อน

    Wow!!! How can I get a copy?

  • @sanunitwaibu529
    @sanunitwaibu529 4 หลายเดือนก่อน

    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.

  • @sanunitwaibu529
    @sanunitwaibu529 4 หลายเดือนก่อน

    bro i have been following you for a long time. thanks for this!. can you please share 64-bit codes.

  • @MaicoMejorada
    @MaicoMejorada 4 หลายเดือนก่อน

    error when you cancel the embedding of attachment

  • @BlessedGlory-n1f
    @BlessedGlory-n1f 4 หลายเดือนก่อน

    I had an error after saving and running the code

  • @danp6101
    @danp6101 4 หลายเดือนก่อน

    it doesn't work

  • @danp6101
    @danp6101 4 หลายเดือนก่อน

    it doesn't work

  • @محمودعسكر-ل3ض
    @محمودعسكر-ل3ض 4 หลายเดือนก่อน

    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.

  • @nmagarjhp
    @nmagarjhp 5 หลายเดือนก่อน

    Great 👍🏻 thanks 🙏

  • @davymaro
    @davymaro 6 หลายเดือนก่อน

    Vert nice tuts

  • @vigneshsa8806
    @vigneshsa8806 7 หลายเดือนก่อน

    Please avoid background music.

  • @Ultimatebeatdastreet
    @Ultimatebeatdastreet 7 หลายเดือนก่อน

    Worked. Thanks

  • @Marcus-jh7lg
    @Marcus-jh7lg 7 หลายเดือนก่อน

    Sorry Sir, I encounter “bad DLL calling convention” error 49 How can I resolve. Many thanks inadvance

  • @AMJADALI858
    @AMJADALI858 8 หลายเดือนก่อน

    Nice and useful trick Thank you ❤

  • @trader.fx1
    @trader.fx1 9 หลายเดือนก่อน

    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 .

  • @maurizioraimondi2937
    @maurizioraimondi2937 9 หลายเดือนก่อน

    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

  • @teachersjoint5919
    @teachersjoint5919 11 หลายเดือนก่อน

    I love this

  • @trilochanjena3836
    @trilochanjena3836 ปีที่แล้ว

    how to show last login detail in userform

  • @smithjohn7815
    @smithjohn7815 ปีที่แล้ว

    Can you please explain why do we need the function " getsheets"?

  • @trilochanjena3836
    @trilochanjena3836 ปีที่แล้ว

    bro.. if both txtuser and txtpassword remain blank and click login button it gets successful login.. plz guide

  • @mohammedarmoosh990
    @mohammedarmoosh990 ปีที่แล้ว

    Unfortunately ,it does not work ,it gives compile error that : Variable not defined ( wHandle). How to solve ? Thank you

    • @proyecto2148
      @proyecto2148 11 หลายเดือนก่อน

      Dim wHandle as Long

    • @proyecto2148
      @proyecto2148 11 หลายเดือนก่อน

      Dim wHandle as Long

  • @MohAboAbdo
    @MohAboAbdo ปีที่แล้ว

    Thank you so much Sir

  • @adrashidkhan8303
    @adrashidkhan8303 ปีที่แล้ว

    Sir please make videos on ms Access also

  • @MohAboAbdo
    @MohAboAbdo ปีที่แล้ว

    Thank you so much

  • @Viji_nkl
    @Viji_nkl ปีที่แล้ว

    you doing great help for excel community brother

  • @danp6101
    @danp6101 ปีที่แล้ว

    video would be so much better if there were no background music.

  • @teachersjoint5919
    @teachersjoint5919 ปีที่แล้ว

    Good work snr. Keep it up...

  • @teachersjoint5919
    @teachersjoint5919 ปีที่แล้ว

    GOOD JOB

  • @HUSSAINKHAN-zp9pt
    @HUSSAINKHAN-zp9pt ปีที่แล้ว

    Incomplete Video.... Skipped Video near "randomstring = str" Add complete video or provide the Practice file.. Thank you

  • @radhanathsikder1921
    @radhanathsikder1921 ปีที่แล้ว

    Set expired date 2023 to 31 March 2024. 1 April open the file ask password excel vba code. Please send me this code 🙏🙏

  • @abcd2-k4s
    @abcd2-k4s ปีที่แล้ว

    Sir clear or delete can not apply.how clear textbox in this way

  • @wahdateummattv
    @wahdateummattv ปีที่แล้ว

    Dear sir please practice file link

  • @abcd2-k4s
    @abcd2-k4s ปีที่แล้ว

    Wow such a beautiful work ❤❤❤❤❤❤❤ Lovely 🌹 Again thankyou

  • @donnagray9770
    @donnagray9770 ปีที่แล้ว

    I keep getting this data error "Method or data member not found" and it highlights the .FolderExists Can you help? Thank you

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      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.

  • @m-squaredcontractors9720
    @m-squaredcontractors9720 ปีที่แล้ว

    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.

  • @reunim8303
    @reunim8303 ปีที่แล้ว

    Excel safety is weak so it is difficult to protect

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      Yes it is but you can certainly get around it.

  • @hi-hy4gd
    @hi-hy4gd ปีที่แล้ว

    Thanks you 👍🙏

  • @shahidulshub
    @shahidulshub ปีที่แล้ว

    thanks you souch , I am Shahidul from Bangladesh ❤. hoop you better life 💪

  • @nyuiemediatsoucharles677
    @nyuiemediatsoucharles677 ปีที่แล้ว

    Courage.....

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      I appreciate it very much. Thank you for the encouragement.

  • @nyuiemediatsoucharles677
    @nyuiemediatsoucharles677 ปีที่แล้ว

    Cogratulation! Goog job.

  • @sanaokarian6169
    @sanaokarian6169 ปีที่แล้ว

    بھائی جان۔۔ کوڈنگ کے دوران ماوس کرسر تو سائیڈ پہ رکھ دیا کریں۔۔شکریہ

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      Well, I can not read Arabic however, I am delighted that you reached out to me. Thank you very much.

  • @joteccodingclinic640
    @joteccodingclinic640 ปีที่แล้ว

    teach us how to create school management system

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      Thank you for your interest. I will do that soon.

  • @sanunitwaibu529
    @sanunitwaibu529 ปีที่แล้ว

    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 🇹🇿

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      If I may, which item would you want to apear an disappear every second?

    • @sanunitwaibu529
      @sanunitwaibu529 ปีที่แล้ว

      @@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.

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      Ok

    • @rafitsolutions4533
      @rafitsolutions4533 ปีที่แล้ว

      Watch this Tutorial for answer: th-cam.com/video/Zu1rGl83T9Q/w-d-xo.html

    • @sanunitwaibu529
      @sanunitwaibu529 ปีที่แล้ว

      @@rafitsolutions4533 Bro thanks a lot you are a legend when It comes to VBA CODING. welcome in Tanzania 🇹🇿 🛫🛬

  • @ofi2701
    @ofi2701 ปีที่แล้ว

    Voz de pato