Wednesday, February 17, 2016

[Solution] Activating a cell when a userform is hidden

Activating a cell when a userform is hidden

Hello
I have set the Exit sub of the last combo box in my userform to give the focus to a specific cell on the sheet.
 
This is the code
 
Private Sub cboCategory_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Sheets("Entry").Activate
              Range("b202").End(xlUp).Select
                          Selection.Offset(0, 7).Activate
                                   ActiveCell.Select
  
  Me.Hide
End Sub
It works, but I still have to click in the cell that the offset function selects before I can enter data with the keyboard.
 
How do I re-write the code so I don't have to click in the cell before I start typing.
 
Thankyou in advance.

Solutions to the Problem Activating a cell when a userform is hidden


Try using
 
Unload Me
 
instead of
 
Me.Hide
 
If you need to preserve control values, store them in global variables or in worksheet cells before unloading the userform.


Click here to download the registry repair application


Another Safe way to Repair the problem: Activating a cell when a userform is hidden:

Click here to download the registry repair application .

How to Fix Activating a cell when a userform is hidden with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: Cannot open xlr files in Windows 7 asus support Display driver has stopped responding and has recovered Display driver NVIDIA compatible Windows Vista Kernel Mode Driver Version 257 21 stopped responding and has successfully recovered asus support New laptop with Windows can t print on network printer tied to desktop running Vista asus com Should you run registry cleaners on Windows 7 asus driver Startup enters Boot Manager instead of booting directly to Windows 7 asus driver download Why doesn t Windows ever start the same way twice Rarely will it load all the programs it is supposed during bootup asus com Windows update error 80070002 Windows 7 asus drivers The best way to Uninstall an Asus Enhanced Show Driver,Bug in Windows 7 Calculator ati radeon hd 4800 driver Failure of Update IE 10 for Windows 7 Error Code 9C59 ATI Radeon HD 4650 Drivers Messages to Groups using Windows Mail ati radeon driver download Random Windows 7 BSoDs Kernel Data Inpage Error and occasional Can t open this item etc errors ati graphics driver update Start button doesn t work Windows 7 64Bit ati radeon hd 5450 drivers Windows Explorer has stopped working Windows 7 64 bit radeon driver Windows Recovery Disk vs Manufacturers Recovery Disc ati drivers windows 7 Go to OSToto’s official website to download and install Driver Talent.,8.1 Sometimes Wakes From Sleep And Sometimes Doesn't,All Word Documents Changed To "Office Open XLM Document" And De-Formatted After Windows 7 Update,Accessing A Vista Shared Folder With Win 7 .... Not Easy Thing!,After Installing And Uninstalling Firefox I Can't Access Internet At All,Alt-Tab Always Shows Two Latest Word Windows
Read More: How to Resolve - \"Non-existent\" add-in causing problems?,How to Resolve - Minimizing and Expanding multiple word documents. When I expand one document, two expand. How do I stop this??,How to Resolve - no default gateway in windows 7?,Solution to Error: Insert row based on cell value,How to Fix - Saving a file?,Are registry cleaners and defrag(s) needed?,An urgent need to get my email account *** Email address is removed for privacy *** back. It has been unblocked permenamently.,Are downlaod speeds fater over Wi-Fi or Ethernet .,are pro-e and katia softwares of mechanical engineering compatible with windows vista?,Comparing data in two worksheet's column using macro. Excel 2007

1 comment:


  1. خدمات نقل الاثاث متعددة لدينا حيث يوجد لدينا خبرة في كيفية التعامل مع العملاء في تنفيذ اعمال فلدينا مدينة مكة افضل شركة نقل اثاث بمكة التي تتميز بالدقة في تنفيذ اعمال وتوصيل الاثاث من الباب لاننا نمتلك عمال متميزون في شركة نقل عفش بمكة فعليكم التواصل معنا من اجل الاستفادة من الخدمات التي نقدمها كل هذا ايضا تلاقه في مدينة الدمام من خلال التواصل مع شركة نقل اثاث بالدمام التي تمتلك فنين متميزين في اعمال الفك والتركيب كما لديها اسطول سيارات مجهز يساعدها علي الوصول الي منزلك الجديد فكل شئ يكون جاهز مع شركة نقل عفش بالدمام التي اثبتت انها نقل شركة لديها خبرة كبيرة في مجال نقل الاثاث
    كما يوجد لدينا خبرة في خدمات نقل الاثاث بجدة من خلال
    شركة نقل اثاث بجدة
    شركة نقل عفش بجدة

    ReplyDelete