Dear all,
Sorry for asking late.
I use the code from KRIS and put in SHANKAR file, however, the below error
happened. Could SHANKAR please share your new file with KRIS code?
Also, I found there is some output in the "Intermediate" window, could
anyone provide some information/ resources on how
Dear Noorain
The query solved by Mr KRIS krishnak...@gmail.com is catering my need.
Thank you for your cooperation my dear friend.
On Tue, Mar 20, 2012 at 6:02 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> Please see attached sheet.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://nooraina
Good evening Sir,
Tons for thanks for solving my query by sparing your valuable time. I
tried your code and it is removing the options in the datasheet. Whereas,
what I want is, at the opening of the datasheet it should have hidden data
options and as per the tick marked checkbox data they have
You may prefer using radio button instead.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Tuesday, March 20, 2012 1:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ checkbox query
Dear experts
I have attached an excel file
Hi
Create a commandbutton. And put this code in the userform module.
Dim Rng As Range
Private Sub CommandButton1_Click()
Dim i As Long
Application.ScreenUpdating = False
Rng.Rows.Hidden = False
With Me
For i = 0 To .Controls.Count - 1
Dear experts
I have attached an excel file containing data of qualification. On the
userform I created check boxes with similar to the datasheet data.
I need action like, only the tickmarked check box data only shown on the
data sheet all other have to go in hidden mode (even in print also).
wa
