Hi there,
I am using a userform with a Excel Spreadsheet within the userform. I am
using this to store all the data needed to be retured within the userform.

There is a section that returns specific data from the spreasheet, what i am
after is a way to then sort the information.

I need to sort by column within this embedded spreadhseet using vba. If
anyone can help that would be much appriciated.

Can i just say that at noo time is any information inserted, pasted, or
placed on the activeworkbook it is the embedded excel spreadsheet within the
userform that contains the information.

many thanks
paulw

request is too vague. Why don't you use the record macro (tools menu -
macro) and record wihile you manually perform the sort operations. Then use
the macro code to create your own VBA. If you need aditional help post the
learn macro on this site and we will help.

"PaulW" wrote:

Hi there,
I am using a userform with a Excel Spreadsheet within the userform. I am
using this to store all the data needed to be retured within the userform.

There is a section that returns specific data from the spreasheet, what i am
after is a way to then sort the information.

I need to sort by column within this embedded spreadhseet using vba. If
anyone can help that would be much appriciated.

Can i just say that at noo time is any information inserted, pasted, or
placed on the activeworkbook it is the embedded excel spreadsheet within the
userform that contains the information.

many thanks
paulw

Hi Joel,

Thanks for replying. Apologies for the vaguenses, i'll try again!

1. I have a userform that uses the directx OCM11 Spreadsheet function (added
to the toolbar). This sits on a mulitpage and holds all my source data hidden
from view.

2. On the Userform i have series of Textboxes which i have programmed to
pull data from the OCM11 Spreadsheet into view (This is based on set
criteria, ie view all open files, closed files etc by pushing togglebuttons)

3. I am trying to programme buttons (one for each row) that will sort the
data on view in the textboxes AZ / ZA based on the togglebutton True / False.

4. I have tried recording a macro and looking at the code it produces but
the recordde cannot see what is completed on the activex application. I have
also tried all manner of sorting code that works on a spreadsheet, but will
not translate to the OCM11 spreadsheet. There are sorting buttons on the
application so i know it is possible!

I hope this claifies the situation a little more.

Any help gratefully accepted.

Many thanks
PaulW


"Joel" wrote:

request is too vague. Why don't you use the record macro (tools menu -
macro) and record wihile you manually perform the sort operations. Then use
the macro code to create your own VBA. If you need aditional help post the
learn macro on this site and we will help.

"PaulW" wrote:

Hi there,
I am using a userform with a Excel Spreadsheet within the userform. I am
using this to store all the data needed to be retured within the userform.

There is a section that returns specific data from the spreasheet, what i am
after is a way to then sort the information.

I need to sort by column within this embedded spreadhseet using vba. If
anyone can help that would be much appriciated.

Can i just say that at noo time is any information inserted, pasted, or
placed on the activeworkbook it is the embedded excel spreadsheet within the
userform that contains the information.

many thanks
paulw

I don't think I can help. The problem is I don't have OCM11. You will need
to run Application.XXXXX commands that I would not be able to test. You arre
right the application codes do not show up on recorded macros.

"PaulW" wrote:

Hi Joel,

Thanks for replying. Apologies for the vaguenses, i'll try again!

1. I have a userform that uses the directx OCM11 Spreadsheet function (added
to the toolbar). This sits on a mulitpage and holds all my source data hidden
from view.

2. On the Userform i have series of Textboxes which i have programmed to
pull data from the OCM11 Spreadsheet into view (This is based on set
criteria, ie view all open files, closed files etc by pushing togglebuttons)

3. I am trying to programme buttons (one for each row) that will sort the
data on view in the textboxes AZ / ZA based on the togglebutton True / False.

4. I have tried recording a macro and looking at the code it produces but
the recordde cannot see what is completed on the activex application. I have
also tried all manner of sorting code that works on a spreadsheet, but will
not translate to the OCM11 spreadsheet. There are sorting buttons on the
application so i know it is possible!

I hope this claifies the situation a little more.

Any help gratefully accepted.

Many thanks
PaulW


"Joel" wrote:

request is too vague. Why don't you use the record macro (tools menu -
macro) and record wihile you manually perform the sort operations. Then use
the macro code to create your own VBA. If you need aditional help post the
learn macro on this site and we will help.

"PaulW" wrote:

Hi there,
I am using a userform with a Excel Spreadsheet within the userform. I am
using this to store all the data needed to be retured within the userform.

There is a section that returns specific data from the spreasheet, what i am
after is a way to then sort the information.

I need to sort by column within this embedded spreadhseet using vba. If
anyone can help that would be much appriciated.

Can i just say that at noo time is any information inserted, pasted, or
placed on the activeworkbook it is the embedded excel spreadsheet within the
userform that contains the information.

many thanks
paulw

Thanks for looking anyway, i know its fairly untested ground as most people
only stick to the toolbar options that are defult.

If at first i fail, i'll try and try again.
Thanks
PaulW

"Joel" wrote:

I don't think I can help. The problem is I don't have OCM11. You will need
to run Application.XXXXX commands that I would not be able to test. You arre
right the application codes do not show up on recorded macros.

"PaulW" wrote:

Hi Joel,

Thanks for replying. Apologies for the vaguenses, i'll try again!

1. I have a userform that uses the directx OCM11 Spreadsheet function (added
to the toolbar). This sits on a mulitpage and holds all my source data hidden
from view.

2. On the Userform i have series of Textboxes which i have programmed to
pull data from the OCM11 Spreadsheet into view (This is based on set
criteria, ie view all open files, closed files etc by pushing togglebuttons)

3. I am trying to programme buttons (one for each row) that will sort the
data on view in the textboxes AZ / ZA based on the togglebutton True / False.

4. I have tried recording a macro and looking at the code it produces but
the recordde cannot see what is completed on the activex application. I have
also tried all manner of sorting code that works on a spreadsheet, but will
not translate to the OCM11 spreadsheet. There are sorting buttons on the
application so i know it is possible!

I hope this claifies the situation a little more.

Any help gratefully accepted.

Many thanks
PaulW


"Joel" wrote:

request is too vague. Why don't you use the record macro (tools menu -
macro) and record wihile you manually perform the sort operations. Then use
the macro code to create your own VBA. If you need aditional help post the
learn macro on this site and we will help.

"PaulW" wrote:

Hi there,
I am using a userform with a Excel Spreadsheet within the userform. I am
using this to store all the data needed to be retured within the userform.

There is a section that returns specific data from the spreasheet, what i am
after is a way to then sort the information.

I need to sort by column within this embedded spreadhseet using vba. If
anyone can help that would be much appriciated.

Can i just say that at noo time is any information inserted, pasted, or
placed on the activeworkbook it is the embedded excel spreadsheet within the
userform that contains the information.

many thanks
paulw