user interface

Hi all, I am new to power tools and data science, I have a little project of mine to make a “search engine-like" interface for my dataset. Can any advice on the direction/ things that I should be digging into? (i.e. if power bi or other tools (SQL) offer ways to achieve the result? if...

I am used to seeing two windows on the left; one over the other. Then Tools up from the bottom and code on the right with all windows sizing in unison. That always felt like that was the default. But somethings changed in my editor. When I opened the edited recently I noticed that the...

I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...

I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...

I am new to VBA and need some help getting started so bear with me here. I have names and information in sheet2 and a user interface in sheet1. I am trying to edit names and their corresponding information in sheet1 by picking the name to edit through a userform listbox and having their...

Greetings, Hi, & Hello, Many thanks to all of you who heave helped me get to this point in my project. I have one last hurdle to clear involving a UI. It has 5 buttons (including the cancel). Basically it has a dropdown for "Department" that when selected populates the appropriate products...

In my worksheet I created code and a module so that when I double-click cells in column N a userform will open up. I need to pull information from the other columns in the same row that was used to access the form to populate text boxes in the userform. I am new to <acronym title="visual...

Hi guys! I've developed two excel workbook recently, one of those is an excel-vba and the other on is a linked simple workbook which contains the excel-vba's required data. My excel-vba workbook contains a command button in its first worksheet and some calculation steps including equations...

INTRODUCTION This is an attempt at creating an excel database for work that will allow employees to identify who is handling a particular task for a given client. Excel is pretty much the only option since most employees are familiar with the application and almost no one knows how to use MS...

Hi, I am a complete beginner to excel VBA and macros. I have an excel spreadsheet which I want to use like a daily meal planner based on nutritional requirements. The first column is the names of nutrients found in food such as calcium, vitamin A, protein, etc. Each following column's first...