How to simulate "DataForm" in VBA
 

Hi,

Can some please let me know a sample code for simulating the "Form"
found under "Data" in Excel 2003?

Thanks,
Baapi:confused:


--
Baapi
------------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

From the macro recorder

Range("A1:H1").Select
ActiveSheet.ShowDataForm


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Baapi" wrote in message
...

Hi,

Can some please let me know a sample code for simulating the "Form"
found under "Data" in Excel 2003?

Thanks,
Baapi:confused:


--
Baapi
------------------------------------------------------------------------
Baapi's Profile:
http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

I've already designed a form and a lot of data input happenns through
it. My requirement in particular is the vertical scrollbar that we see
in the standard form. I have two buttons in my form named "Next" and
"Previous". But, I'm not able to provide a scroll option to the users
in my project.

Can you help me on that?

Thanks,
Girish


--
Baapi
------------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

I've use that but the scroll_click just fires the same routines as your Next
and previous.
You just need to set the scroll bar max to the number of records and keep it
in sync with the next/previous clicks.

NickHK

"Baapi" wrote in
message ...

I've already designed a form and a lot of data input happenns through
it. My requirement in particular is the vertical scrollbar that we see
in the standard form. I have two buttons in my form named "Next" and
"Previous". But, I'm not able to provide a scroll option to the users
in my project.

Can you help me on that?

Thanks,
Girish


--
Baapi
------------------------------------------------------------------------
Baapi's Profile:
http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

That should read "I've never used that form....."

NickHK

"NickHK" wrote in message
...
I've use that but the scroll_click just fires the same routines as your
Next
and previous.
You just need to set the scroll bar max to the number of records and keep
it
in sync with the next/previous clicks.

NickHK

"Baapi" wrote in
message ...

I've already designed a form and a lot of data input happenns through
it. My requirement in particular is the vertical scrollbar that we see
in the standard form. I have two buttons in my form named "Next" and
"Previous". But, I'm not able to provide a scroll option to the users
in my project.

Can you help me on that?

Thanks,
Girish


--
Baapi
------------------------------------------------------------------------
Baapi's Profile:
http://www.excelforum.com/member.php...o&userid=27333
View this thread:
http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

What about the rectangular shape that we see in between the
Scroll_Click? How do I program that?


--
Baapi


------------------------------------------------------------------------
Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811

How to simulate "DataForm" in VBA
 

Private Sub ScrollBar1_Change() ?

NickHK

"Baapi" wrote in
message ...

What about the rectangular shape that we see in between the
Scroll_Click? How do I program that?


--
Baapi


------------------------------------------------------------------------
Baapi's Profile:
http://www.excelforum.com/member.php...o&userid=27333
View this thread: http://www.excelforum.com/showthread...hreadid=556811