VBA help making a Database Viewer

[khag]

Hello guys!

I need to make a database viewer on excel, a simple form to show some infos in one place.
i`m new with VBA, so i`m trying to do by myself, but every time i got stuck with the code.

here`s the thing, there`s more than 1 sheet and i need to work with it dynamically and with a image.

The base layout

Can someone help me with the code? Or at least show me the path to learn this, please!
Here`s a piece of code that i built, i don`t know if is really usable to do this.

Private Sub UserForm_Initialize()

    Dim sh As Worksheet

    On Error Resume Next
    
    If cmbSheets.ListCount <> ThisWorkbook.Sheets.Count Then
    cmbSheets.Clear
    For Each sh In ThisWorkbook.Sheets
    If sh.Visible Then
    cmbSheets.AddItem xSheet.Name
    End If

    Next sh
    sh.Activate
    
    End If
End Sub

Thanks!!

 

[Saurabhj]

Hi, Please explain what you are trying to achieve.

What the combo box contains in user form?
If user select any value, what is the expected result?

On activating the user form, are you trying to show sheets name ?

 

[khag]

Hi, Please explain what you are trying to achieve.

What the combo box contains in user form?
If user select any value, what is the expected result?

On activating the user form, are you trying to show sheets name ?

Thank you so much for answering!

I want to select a sheet with the ComboBox and activate it

The listBox will show a column from this sheet, like "B:B". When I select a value from listbox, will show values in TextBoxes from a row of the selected column of the selected sheet on the ComboBox, .
Like, the listbox shows "B:B", if i select a especific row, like"B3" value on the listBox, the TextBoxes will show the subsequent especific value from the same row, like txtName = "C3", txtPrice = "D3", txtType = "E3".
The image will get a link from a local path in the same row too. (like imgProduct = "G3")
And the "TextBox Name (Vendor Sheet)" will get a value from the same selected row, like "C3" but from another sheet.

Sorry if I wasn't very clear
I just keep thinking it`s an easy task, but a really don`t have enough knowledge in VBA yet to do this

 

[Saurabhj]

Hi, Can you please share your sheet using GoogleDrive or any other drive .


Thanks,
Saurabh

 

[khag]

Hi, Can you please share your sheet using GoogleDrive or any other drive .


Thanks,
Saurabh

Hi!

I made a simplified version of my sheet because of personal data

My sheet

Thanks a lot!!

 

[Saurabhj]

Hi,

Attached is the required sheet. Please use jpg format for images.

Download File

Thanks,
Saurabh

 

[khag]

Hi,

Attached is the required sheet. Please use jpg format for images.

Download File

Thanks,
Saurabh

Thank you soooo much!!!

 

[Saurabhj]

Thanks for the feedback.