Viewing a worksheet within a Userform
 

This may seem an odd question. I have built an excel document tha
effectively works as an issue tracker; new data can be submitted by
userform, existing data can be edited via a userform.

What I would now like to do is provide a view of what issues are ther
without having to view the entire worksheet.

I would like a userform that effectively embeds the worksheet dependan
upon user defined criteria, such as any issues logged by them
effectively reproducing the effect of an autofilter but within
modeless userform rather than within the worksheet itself.

The data sheet is basically made up of the following headings, and an
new data is just populated in the next available row.

Name - Position - Manager - Created - Ref - Category - Notes - Closed

If anyone can nudge me in the right direction or has seen somethin
similar before that would be great.

Thanks

--
chris_waldi
-----------------------------------------------------------------------
chris_waldie's Profile: http://www.excelforum.com/member.php...fo&userid=1885
View this thread: http://www.excelforum.com/showthread.php?threadid=50634

Viewing a worksheet within a Userform
 

Load a multicolumn Listbox on a userform by looping through your data and
adding the rows that meet the criteria selected by the user.

--
Regards,
Tom Ogilvy

"chris_waldie"
wrote in message
news:chris_waldie.22gbay_1138630501.5588@excelforu m-nospam.com...

This may seem an odd question. I have built an excel document that
effectively works as an issue tracker; new data can be submitted by a
userform, existing data can be edited via a userform.

What I would now like to do is provide a view of what issues are there
without having to view the entire worksheet.

I would like a userform that effectively embeds the worksheet dependant
upon user defined criteria, such as any issues logged by them,
effectively reproducing the effect of an autofilter but within a
modeless userform rather than within the worksheet itself.

The data sheet is basically made up of the following headings, and any
new data is just populated in the next available row.

Name - Position - Manager - Created - Ref - Category - Notes - Closed

If anyone can nudge me in the right direction or has seen something
similar before that would be great.

Thanks.


--
chris_waldie
------------------------------------------------------------------------
chris_waldie's Profile:
http://www.excelforum.com/member.php...o&userid=18853
View this thread: http://www.excelforum.com/showthread...hreadid=506341

Viewing a worksheet within a Userform
 

Thanks Tom. Just the right nudge I needed.


--
chris_waldie
------------------------------------------------------------------------
chris_waldie's Profile: http://www.excelforum.com/member.php...o&userid=18853
View this thread: http://www.excelforum.com/showthread...hreadid=506341

Viewing a worksheet within a Userform
 

Ok.

I have made some initial progress and can populate the listbox with al
entries matching a single criteria. Before I proceed though, I did hav
a couple more questions that have not revealed themselves to me yet.

Can I control the format within a multi column listbox.

For example some of my fields are dates of a specific format which th
listbox displays in the default mm/dd/yyyy.

Also, can I allow for textwrapping as some of the entries contain to
much text just to have a large column width defined?

And can the lisbox contain a grid to separate items visually?

The listbox is a good start, although visually it will need som
tweaking for me to proceed with it as a solution.

Thanks again

--
chris_waldi
-----------------------------------------------------------------------
chris_waldie's Profile: http://www.excelforum.com/member.php...fo&userid=1885
View this thread: http://www.excelforum.com/showthread.php?threadid=50634

Viewing a worksheet within a Userform
 

All the data in the listbox is a string, so you can format you dates and
enter them as strings as you load them

Multilines/text wrapping in a listbox row - I don't believe so.

A grid, no I don't believe that is supported either

You might want to try the Office Web Components - spreadsheet component

or use a 3rd party grid control.

--
Regards,
Tom Ogilvy




"chris_waldie"
wrote in message
news:chris_waldie.22glhn_1138643702.3073@excelforu m-nospam.com...

Ok.

I have made some initial progress and can populate the listbox with all
entries matching a single criteria. Before I proceed though, I did have
a couple more questions that have not revealed themselves to me yet.

Can I control the format within a multi column listbox.

For example some of my fields are dates of a specific format which the
listbox displays in the default mm/dd/yyyy.

Also, can I allow for textwrapping as some of the entries contain too
much text just to have a large column width defined?

And can the lisbox contain a grid to separate items visually?

The listbox is a good start, although visually it will need some
tweaking for me to proceed with it as a solution.

Thanks again.


--
chris_waldie
------------------------------------------------------------------------
chris_waldie's Profile:
http://www.excelforum.com/member.php...o&userid=18853
View this thread: http://www.excelforum.com/showthread...hreadid=506341

Viewing a worksheet within a Userform
 

Thanks again Tom

--
chris_waldi
-----------------------------------------------------------------------
chris_waldie's Profile: http://www.excelforum.com/member.php...fo&userid=1885
View this thread: http://www.excelforum.com/showthread.php?threadid=50634